MX Release 3.1 (H06.23+, J06.12+)

4> select * from employee;

5> show views

6> select * from dept;

7> show views

8> select * from emplist;

SQL>

SQL>repeat -2

show views

VIEW NAMES

-------------------------------------------------------------

EMPLIST MGRLIST

SQL>

• The following example reruns the seventh command in the history buffer:

SQL>repeat 7

show views

VIEW NAMES

-------------------------------------------------------------

EMPLIST MGRLIST

SQL>

• The following example reruns the show views command:

SQL>repeat show

show views

VIEW NAMES

-------------------------------------------------------------

EMPLIST MGRLIST

SQL>

RESET LASTERROR command

The reset lasterror command resets the last error code to zero.

Syntax

RESET LASTERROR

Considerations

You must enter the command in one line.

Examples

The following command resets the last error in the current session:

SQL>select * from emp;

*** ERROR[4082]Object CAT.SCH.EMP does not exist or is inaccessible.

SQL>show lasterror

LASTERROR 4082

SQL>reset lasterror

SQL>show lasterror

LASTERROR 0

RESET LASTERROR command 81