The CALL statement calls an external procedure If the procedure has parameters, a list of values can be passed. The values allowed are the following:
Call procedure PROCEDURE1 with 2 input parameters and 1 output parameter.
CALL MYLIB.PROCEDURE1(1,'abc',?)
The value that is returned in the third parameter is returned to the SQL scripts message tab output area; this is true for all INOUT and OUT parameters.
If the procedure returns a result set, it is displayed as output in either a new window or as another tab in the output area of Run SQL scripts, depending on your current setting in SQL scripts.
For more information, see CALL in the SQL Reference topic in the
Information Center.