DB2 graphic  QMF Version 8

QMF FORM use

If you do not specify a FORM on the RUN command, a default FORM will be created based on the returned result set. A FORM can be specified on the RUN command when you are running a QUERY with a SELECT statement. This same support is provided for a stored procedure that returns result sets. If the stored procedure returns more than one result set, you can display one of the result sets by specifying its number in the global variable DSQEC_SP_RS_NUM; the rest of the result sets are ignored. In this case, the FORM specified on the RUN command must have a data definition that matches the data returned in the result set. An error message is issued if the FORM definition does not match the data returned in the result set. You can then load a new FORM, modify the existing one, or reset the FORM to a default FORM and rerun the stored procedure.


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