For a non-ABL stored procedure, indicates that the procedure has completed execution and retrieves any return status. For a send–sql–statement stored procedure, closes the SQL cursor used by the procedure.
Syntax
CLOSE STORED-PROCEDURE procedure [integer-field = PROC-STATUS ] [ WHERE PROC-HANDLE = integer-field]
procedure
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.
Notes
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.
You cannot close a send–sql–statement procedure until you have retrieved all row results.
You can close all stored procedures at once with the following 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.