For a RDBMS stored procedure, a PROC-STATUS received value indicates that the procedure has completed execution and makes available the return code value and any output parameters. For a send-sql-statement stored procedure, CLOSE STORED-PROCEDURE closes the SQL cursor used by the procedure, as shown:
CLOSE STORED-PROCEDURE procedure-name [integer-field = PROC-STATUS ] [ WHERE PROC-HANDLE = integer-field]
procedure-name
The name of the stored procedure that you want to close or the built-in procedure name, send-sql-statement.
integer-field = PROC-STATUS
Assigns the return value from a stored procedure to the specified integer field or variable (integer-field).
WHERE PROC-HANDLE = integer-field
An integer field or variable whose value uniquely identifies the stored procedure that produces the results returned from the data source or the SQL cursor of a send-sql-statement stored procedure.
Consider these points concerning the CLOSED STORED-PROCEDURE statement:
If you specified a PROC-HANDLE when you ran a stored procedure, you must specify the PROC-HANDLE when you close the stored procedure.
If you do not specify a PROC-HANDLE, the CLOSE STORED-PROCEDURE statement closes the procedure if there is only one stored procedure running. If there is more than one stored procedure running, an error is returned.
If you specified a PROC-HANDLE when you ran a stored procedure, you must specify the PROC-HANDLE when you close the stored procedure.