Neoview Command Interface (NCI) Guide (R2.3)

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
• 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 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 71).
RUN Command
The RUN command executes the previously executed SQL statement. This command does not
repeat a NCI command.
Syntax
RUN
Considerations
• 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 command executes the previously executed SELECT statement:
SQL>select count(*) from persnl.employee;
(EXPR)
--------------------
62
--- 1 row(s) selected.
SQL>run
(EXPR)
--------------------
62
--- 1 row(s) selected.
SQL>
116 NCI Commands