DB2 graphic  QMF Version 8

Format of the CALL statement

Most simple CALL statements use the following format:

CALL spname(parm1, parm2, parmx)

Example: This basic CALL statement is for a stored procedure that has two input parameters that are defined as decimal data with a precision of five and a scale of two.:

CALL USERAPROC1(123.45,1.22)

For more information about the CALL statement, see DB2 QMF Reference. The QMF supported syntax is slightly different from the DB2 CALL statement.

To enter the CALL statement on the SQL QUERY panel:


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