SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

R-14

Example—RESET LAYOUT

This example 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.

For a description of parameters and their use, see SET PARAM Command on

page S-35.

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



This example clears the values of parameters ?TESTVAL1, and ?TESTVAL2:

>> RESET PARAM ?TESTVAL1, ?TESTVAL2



Suppose that 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

RESET { [ PARAM ] param-name [ ,param-name] ... } ;

{ PARAM * }