|
|
|
DEFINE
Syntax
DEFINE [ variable_name = value ] ;
Description
The DEFINE statement defines a variable and assigns an ASCII string value to it. When you refer to the defined variable in DISPLAY statements, ISQL prints the value.
The DEFINE statement is useful if you have scripts with many DISPLAY statements. You can change a single DEFINE statement to change the value in all of the DISPLAY statements that refer to the variable.
Issuing the DEFINE statement without any arguments displays any currently-defined variables, including those defined through the COMPUTE statement.
Arguments
variable_name
Specifies the name by which the variable can be referred to.
value
The ASCII string that is assigned to the variable. Enclose value in quotes if it contains any non-numeric values.
Example
The following example defines a variable called nestate and assigns the value “NH” to it.
ISQL> DEFINE nestate = "NH" ;
