DB2 graphic QMF Version 8

RESET GLOBAL ALL command

The RESET GLOBAL ALL command deletes the names and values of global variables that have been set using the SET GLOBAL command.

Syntax

>>-- RESET GLOBAL (Variable1, Variable2 ... ------------------------<<

or

>>-- RESET GLOBAL ALL ----------------------------------<<

Parameters

Table 44. RESET GLOBAL ALL Command Parameters
Parameter Description
VariableName Specifies the names of the variables to be deleted. You can name up to 10 variables previously set by the SET GLOBAL command.

ALL deletes the names and values of all variables previously set by the SET GLOBAL command. Even if you do not have several global variables defined, or you do not remember the names of your global variables, you can use this parameter to reset all global variables at one time.

Variables prefixed with DSQ are restricted, and cannot be deleted.

Note:
You can use global variables in queries, procedures, and forms, but not in the DB2 Table Editor.

When you issue the RESET GLOBAL ? command, you are prompted to fill in the names of the variables you want to reset.

On the Global Variable List dialog, you can reset a variable by positioning your cursor on the line you want to delete and pressing Delete.

For example, to delete the values for all global variables that were previously set, type:

RESET GLOBAL ALL

To delete the values only for the variables named DEPT and LOCATION, type:

RESET GLOBAL (DEPT LOCATION

Example

RESET GLOBAL (Variable1, Variable2

or

RESET GLOBAL ALL


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