MX Release 3.1 (H06.23+, J06.12+)

RESET PARAM command

The reset param command clears all parameter values or a specified parameter value in the

current session.

Syntax

RESET PARAM [param-name]

param-name

is the name of the parameter for which you specified a value. Parameter names are

case-sensitive. For example, the parameter ?pn is not equivalent to the parameter ?PN.

param-name can be preceded by a question mark (?), such as ?param-name.

If you do not specify a parameter name, all the parameter values in the current session are

cleared.

Considerations

• You must enter the command in one line.

• To clear several parameter values but not all, you must use a separate reset param command

for each parameter.

Example

The following command clears the setting of the ?sal parameter, and the set param command

sets it to a new value:

SQL>reset param ?sal

SQL>set param ?sal 80000.00

For more information, see “Resetting the parameters” (page 43).

RUN command

The run command runs the previously run SQL statement. This command does not run a previously

run RMXCI command.

Syntax

RUN

Considerations

You must enter the command in one line.

Example

The following command runs the previously run SELECT statement:

SQL>select count(*) from persnl.employee;

(EXPR)

--------------------

--- 1 row(s) selected.

SQL>run

(EXPR)

82 RMXCI commands