DB2 graphic  QMF Version 8

CALL

TSO With ISPF TSO Without ISPF CMS With ISPF CMS Without ISPF CICS
X X X

In order to run a stored procedure from QMF, the user must issue a CALL statement from the SQL Query panel. Once the user has entered a CALL statement, a RUN command is issued to run the stored procedure.

Read syntax diagramSkip visual syntax diagram                        (1)     (2)
>>-CALL--procedure_name-----(-------+----------------+--)------><
                                    |           (3)  |
                                    +-&variable------+
                                    |          (4)   |
                                    +-CONSTANT-------+
                                    |      (5)       |
                                    '-NULL-----------'

Notes:
  1. This identifies the stored procedure to call.
  2. Parameter values can be in, out, or inout parameters.
  3. This identifies a QMF substitution variable to be used as input or output to the stored procedure.
  4. This identifies a CONSTANT to be used as input or output to the stored procedure.
  5. The parameter is a NULL value. The corresponding parameter of a stored procedure must be defined as IN, and the description of the stored procedure must allow for NULL parameters.


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