SET INVISIBLE command
The SET INVISIBLE command hides specified variables from the Prompt Variables dialog.
The Prompt Variables dialog will not request any value for the specified variables. If all local variables are set invisible, the Prompt Variables dialog does not display.
For example, if you have a query select *
from q.staff, where
id=&id or id=&visible and if you run a procedure
run query (&&id=20
, then you will be prompted to enter value for
id and visible variables. Also the id
variable will be defaulted to 20. But if you run the following procedure:
set invisible (id run query (&&id=20
, then you will be prompted to enter a
value for the visible variable only. The id variable will be
set to 20 and will be hidden from the dialog. Also, if you run the following
procedure: set invisible (id visible run query (&&id=20
, then you will not
be prompted to enter any variable values. The id variable will be set to
20 and the visible variable will be set to an empty
string.
Syntax
>>-- SET INVISIBLE ( VariableName1, VariableName2, ... -----<<
Parameters
Parameter | Description |
---|---|
VariableName | The name of variable not to be displayed in the Prompt Variables dialog. |
Example
SET INVISIBLE (Var1, Var2