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

Considerations
This command can be executed in SQL mode. The command requires an SQL terminator.
Examples
SQL>select * from job;
JOBCODE JOBDESC
------- ------------------
100 MANAGER
1234 ENGINEER
450 PROGRAMMER
900 SECRETARY
300 SALESREP
500 ACCOUNTANT
400 SYSTEM ANALYST
250 ASSEMBLER
420 ENGINEER
600 ADMINISTRATOR
200 PRODUCTION SUPV
--- 11 row(s) selected.
SQL> get statistics;
Start Time 2007/09/18 21:45:34.082329
End Time 2007/09/18 21:45:34.300265
Elapsed Time 00:00:00.217936
Compile Time 00:00:00.002423
Execution Time 00:00:00.218750
Table Name Records Records Disk Message Message Lock Lock Disk Process
Accessed Used I/Os Count Bytes Escl Wait Busy Time
NEO.TOI.JOB 2 2 0 4 15232 0 0 363
--- SQL operation complete.
GOTO Command
The GOTO command allows you to jump to a designated point in the command history. The
point in the command history is designated by a LABEL command. All commands executed
after a GOTO statement are ignored until the specified label is set. To set a label, use the “LABEL
Command” (page 103).
Syntax
GOTO {label}
label
is a string of characters without quotes and spaces, or a quoted string.
Considerations
• You must enter the command on one line.
• The GOTO command cannot currently jump back in the command history; it is a forward-only
command.
Examples
These examples show the use of the GOTO and LABEL commands:
SQL> GOTO ViewManagers
SQL> SELECT * FROM Employees; -- skipped
SQL> SHOW RECCOUNT; -- skipped
SQL> LABEL ViewManagers
SQL> SELECT * FROM Managers;
100 NCI Commands