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