Specifying a value with a global variable

You can define global variables with the SET GLOBAL command.

For example, to set a global variable value for the &DEPARTMENT variable, on the QMF command line enter:


You can specify up to 10 variable/value pairs with a single SET GLOBAL command. Separate the values with either commas or blanks. Variable values that are used in queries cannot begin with dashes because the database misinterprets them.

By default, values for global variables persist for the duration of the QMF session or until you reset them. However, the DSQEC_USERGLV_SAV global variable can be set to save global variable values from one session to another.