You can also execute a stored procedure implementation to obtain result sets and load the results into temp-tables. You must define result set(s) target as part of the RUN STORED-PROC statement. You do not explicitly close a STORED-PROC defined this way as you do with buffer methods of retrieving result sets; the LOAD-RESULT-INTO function achieves this goal implicitly.

This is the syntax for the RUN STORED-PROC statement implementation when loading result sets to temp-tables:

RUN STORED-PROC procedure-name

  [ [ LOAD-RESULT-INTO handle [ int = PROC-STATUS ]]
            [NO-ERROR]
       [ ( [ INPUT | OUTPUT | INPUT OUTPUT ]
                         [ PARAM parameter-name = ] expression, ...
       [ INPUT | OUTPUT | INPUT OUTPUT ]
                         [ PARAM parameter-name = ] expression) ]

The RUN STORED-PROC statement sets up the execution of the stored-procedure, retrieves the result set(s), and loads it into the temp-table(s) provided you use the LOAD-RESULT-INTO function. The CLOSE STORED-PROC statement is automatically applied when the result set(s) is loaded into temp-tables because using temp-tables must consume all result sets of the procedure.