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