Select Query--> Confirm Stored Procedure Parameters to confirm the input and output parameters that are sent to the database when running the stored procedure, such as the name of the program and the number of parameters expected.
This option displays when you type a CALL statement in a query window to run a DB2 stored procedure. With this option, QMF for Windows receives information about the parameter data types, modes, and values from the CALL statement, as well as the database server catalog.
Follow these steps to confirm the parameters for a stored procedure:
The Confirm stored procedure parameters option on the Query menu becomes available.
The Confirm Stored Procedure Parameters dialog box opens. Confirm or update the name, data type, mode, and value of each parameter being sent.
An error occurred while running the query. The CALL statement contains an invalid or unsupported syntax.