NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
R-16
Examples—RESET LAYOUT
Examples—RESET LAYOUT
•
The following command resets three report writer layout options to their default
values:
>> RESET LAYOUT RIGHT_MARGIN, LINE_SPACING, PAGE_LENGTH;
RESET PARAM Command
RESET PARAM is an SQLCI command that clears the values of one or more
parameters.
param-name
specifies a parameter to clear.
*
clears the values of all parameters.
See SET PARAM Command
on page S-36 for an explanation of what parameters
are and how you use them.
Considerations—RESET PARAM
•
The RESET PARAM command clears the current parameter values. You do not
have to reset a parameter value that you assign using the EXECUTE command
because the assignment applies only to that execution of the command.
•
Parameters you set in the command interpreter (with the PARAM command) before
starting SQLCI are reset for your SQLCI session but are not changed in the
command interpreter.
•
After you clear a parameter, the parameter has no value. If you execute a command
that refers to the parameter, an error message appears.
Examples—RESET PARAM
•
The following command clears the values of parameters ?TESTVAL1, and
?TESTVAL2:
>> RESET PARAM ?TESTVAL1, ?TESTVAL2
•
Suppose you use the TACL PARAM command to set the SAL parameter before
starting SQLCI. During your SQLCI session, you set the parameter again. The
RESET PARAM command in this example resets ?ENUM and ?STATE to no value.
The SAL parameter is also set to no value for the SQLCI session, but when you exit
SQLCI, SAL has the value 140,000 for the TACL process. The ?ENUM parameter
RESET { [ PARAM ] param-name [ ,param-name] ... } ;
{ PARAM * }