README for the HP Neoview Command Interface (NCI) (Upd1 R2.3 SP2)

SQL> LABEL insertBob

SQL> INSERT INTO Employees(SSN, FName, LName) VALUES(123456789, 'Bob', 'Smith');

SQL> EXIT

SHOW ACTIVITYCOUNT

ACTIVITYCOUNT is an alias for RECCOUNT. For more information, see SHOW RECCOUNT.

Example:

SHOW ACTIVITYCOUNT

SHOW ERRORCODE

ERRORCODE is an alias for LASTERROR. For more information, see SHOW LASTERROR.

Example:

SHOW ERRORCODE

EXIT

The EXIT command disconnects from and exits NCI. EXIT can return a status code. If no status

code is specified, zero is returned by default. In addition, a conditional statement can be appended

to the command.

Syntax:

EXIT [ WITH ] [ status ] [ IF { condition } ]

status any 1 byte integer.

For more information, see IF…THEN about condition. status is a shell return value and the

range of allowable values is platform dependent. The examples below are equivalent:

Example:

SQL> EXIT -1 IF LASTERROR <> 0

SQL> EXIT WITH -1 IF LASTERROR != 0

SQL> EXIT WITH 82 IF LASTERROR == 4082

SQL> EXIT -- default status is 0

QUIT

The QUIT command is an alias for the EXIT command. See the EXIT command for more

information.