LIMIT LOCAL command
The LIMIT LOCAL command specifies values for existing local variables.
The parameters set using this command are the only ones that will display in the Prompt Variables window when you run the object.
Any new local variables created are valid only for the current query, report, or dashboard.
Syntax
>>-- LIMIT LOCAL ( VariableName = Value, ... -----<<| Parameter | Description |
|---|---|
| VariableName | The name of the local variable to set available values. |
| Value | The value or list of values which will be available to select from in the Prompt Variables window |
Example
LIMIT LOCAL (id=10;20;30
LIMIT LOCAL (TableName=Q.STAFF;Q.INTERVIEW;