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.
Syntax
>>-- SET LOCAL ( VariableName = Value, ... -----<<Parameters
| 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. |
Example
SET LOCAL (Var1=abc, Var2=def