SET GLOBAL command

The SET GLOBAL command sets the values of existing global variables or creates variables and values.

Syntax

>>-- SET GLOBAL ( VariableName = Value, ... -----<<
                  +- LIFETIME = CURRENT/PERMANENT -+
Parameter Description
VariableName The name of the global variable to set or create. Global variable names can be from 1 to 17 characters long. Variables whose names begin with DSQ are restricted, and can not be created or deleted.
Value The value to give the global variable. The value can be from 1 to 55 characters long. The values of variables whose names begin with DSQ are restricted. See the "Working with global variables" topic for more information.
LIFETIME The period during which the variable is available for use:
  • CURRENT - the variable is available in the current session (default value).
  • PERMANENT - the variable is available persistently.

Example

SET GLOBAL (Var1=abc, Var2=def LIFETIME = PERMANENT