The following syntax shows the RUN STORED-PROC statement and all options that can be used with the statement. However, keep in mind that not all options shown can be used simultaneously. 

RUN STORED-PROCEDURE procedure-name

[[LOAD-RESULT-INTO <handle> [<int> = PROC-STATUS]]| 
     [<int> = PROC-HANDLE]]     
     [ NO-ERROR ]    [([INPUT|OUTPUT|INPUT OUTPUT][PARAM parameter-name =]expression, ...
        [INPUT|OUTPUT|INPUT OUTPUT][PARAM parameter-name =]expression )]
Note: In the RUN STORED-PROCEDURE syntax, note that the <handle> is either a pure handle or a handle that points to a temp-table. For more information about using the temp-table handle with the LOAD-RESULT-INTO phrase, see CLOSE STORED-PROCEDURE statement.
CLOSE STORED-PROCEDURE procedure-name
    [integer-field = PROC-STATUS ]
    [ WHERE PROC-HANDLE = integer-field]

The CLOSE STORED-PROCEDURE is not used when the LOAD-RESULT-INTO keyword is used with the RUN STORED-PROCEDURE statement. See the .

For valid combinations and usage of these syntax elements, see:

The following sections describe the syntax elements and options in detail. These sections also present examples that describe typical situations in which you might use the various options that the RUN STORED-PROC statement supports.