DB2 graphic  QMF Version 8

Specifying values for variables using global variables

You can specify values for substitution variables by defining global variables with the SET GLOBAL command. A global variable keeps its value until you reset it, or until you end the QMF session.

For example, to set a global variable value for the &DEPARTMENT variable, enter:

SET GLOBAL (DEPARTMENT=38

You can specify up to 10 variable values. Separate the values with commas or with blanks.

You can use the SET GLOBAL command to prompt for all the values in your procedure at the same time, as in the following example:

"SET GLOBAL (LASTNAME=&LASTNAME,DEPT_NUM=&DEPT_NUM";


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