Neoview Script Guide (R2.2)
DEPT EMPLOYEE JOB PROJECT
SQL>
RESET LASTERROR Command
The RESET LASTERROR command resets the last error code to 0.
Syntax
RESET LASTERROR
Considerations
• In the Neoview Script interface, 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
• 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.
RESET LASTERROR Command 105