SET LOCAL command

The SET LOCAL command sets the values of existing local variables or creates new variables and values.

Variables specified in SET LOCAL are available only for the current object (query, report, or dashboard) and do not appear in Global Variables list or affect other procedures.


>>-- SET LOCAL ( VariableName = Value, ... -----<<


Parameter Description
VariableName The name of the local variable to set or create. Local 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 local variable. The value can be from 1 to 55 characters long. The values of variables whose names begin with DSQ are restricted.


SET LOCAL (Var1=abc, Var2=def