DB2 graphic QMF Version 8

Confirm stored procedure parameters

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:

  1. Select the server where the stored procedure is saved.
  2. Select File--> New--> SQL Query.
  3. Type a CALL statement.

    The Confirm stored procedure parameters option on the Query menu becomes available.

  4. Select the Confirm stored procedure parameters option.
  5. Select Query--> Run.

    The Confirm Stored Procedure Parameters dialog box opens. Confirm or update the name, data type, mode, and value of each parameter being sent.

    Note:
    An error message similar to the following displays if the statement contains errors:
    An error occurred while running the query.
    The CALL statement contains an invalid or unsupported syntax.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004