Syntax

RESET PARAM [param-name]

param-nameis 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-namecan be preceded by a question mark (?), such as ?param-name.

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

Considerations

•In the Neoview Script interface, you must enter the command on one line. The command does not require an SQL terminator.

•You can execute this command only in SQL mode.

•To clear several parameter values but not all, you must use a separate RESET PARAM command for each parameter.

Example

This RESET PARAM command clears the setting of the ?sal (salary) parameter, and the SET PARAM command resets it to a new value:

SQL>reset param ?sal

SQL>set param ?sal 80000.00

For more information, see “Resetting the Parameters” (page 61).

RUN Command

The RUN command executes the previously executed SQL statement. This command does not repeat a Neoview Script interface command.

Syntax

RUN

Considerations

•In the Neoview Script interface, you must enter the command on one line. The command does not require an SQL terminator.

•You can execute this command only in SQL mode.

Example

This RUN command executes the previously executed SELECT statement:

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

(EXPR)

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

62

---1 row(s) selected. SQL>run

(EXPR)

100 Neoview Script Interface Commands