DB2 graphic  QMF Version 8

Notes

  1. QMF will not process three-part names. Only stored procedures at the current location (where QMF is currently connected to) will be run. If a three-part name is entered, QMF will accept it, but an error message will be issued if the location entered does not match the current location.
  2. QMF will not support procedure library or absolute path as part of the stored procedure name that is valid in a DB2 Universal Database server.
  3. Authorization checking is done by the database. The current SQLID must be authorized to run the stored procedure specified in the CALL statement.
  4. DB2 UDB only runs a stored procedure if the number of parameters entered by the user is the same as the number specified in the DB2 UDB catalog definition for the stored procedure. If there is a mismatch, an error message will be displayed.
  5. The user must use a QMF global variable to specify output parameters for a stored procedure if they wish to view the output. The output parameters can then be shown using the SHOW GLOBALS command.
  6. The maximum size of a QMF substitution variable is 32K.
  7. A maximum of 10 QMF global variables may be entered from the SQL Query panel.
  8. The supported maximum number of result sets is 32.
  9. QMF global variables that are used to pass as output parameters to the stored procedure have special initialization requirements. An output parameter with a numeric data type must be initialized to 0. An output parameter with a data type of CHAR must be initialized to blank or NULL.
  10. Parameters that are defined with data types of DATE, TIME, or TIMESTAMP must have their values enclosed in single quotes. QMF handles these data types as character strings.
  11. The following data types are not supported for input/output parameters when running a stored procedure from QMF: VARGRAPHIC, GRAPHIC, LONG GRAPHIC, CLOB, BLOB, DBLOB, ROWID, and all locator data types.
  12. QMF supports the return of the first 32 result sets when a stored procedure that returns result sets is run. Select one by setting the global variable DSQEC_SP_RS_NUM. One is the default setting. To ignore result sets, set the global variable to zero.

How to write a CALL statement with Long Identifiers

A single SQL query line is limited to 79 bytes on the QMF Query panel. An identifier that spans more than one line in a CALL statement entered on the Query panel must be a delimited identifier. Here are some examples showing how to code long CALL statements on the QMF 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