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

SQL>
• Re-execute the SHOW TABLES command:
SQL>repeat show
show tables
TABLE NAMES
-------------------------------------------------------------
DEPT EMPLOYEE JOB PROJECT
SQL>
RESET LASTERROR Command
The RESET LASTERROR command resets the last error code to 0.
Syntax
RESET LASTERROR
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.
116 NCI Commands