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

SQL>
• Re-execute the fifth command in the history buffer:
SQL>repeat 5
show tables
TABLE NAMES
-------------------------------------------------------------
DEPT EMPLOYEE JOB PROJECT
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]
RESET LASTERROR Command 115