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

Considerations
You must enter the command on one line. The command does not require an SQL terminator.
Examples
This command resets the last error in the current session:
SQL>select * from emp;
*** ERROR[4082]Object NEO.SCH.EMP does not exist or is inaccessible.
SQL>show lasterror
LASTERROR 4082
SQL> reset lasterror
SQL>show lasterror
LASTERROR 0
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 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 55).
RUN Command
The RUN command executes the previously executed SQL statement. This command does not
repeat a NCI command.
Syntax
RUN
RESET PARAM Command 105