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

--- 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 91).
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;
SQL> GOTO “View Customers”
SQL> SELECT * FROM Invoices; -- skipped
SQL> LABEL “View Customers”
SQL> SELECT * FROM Customers;
HELP Command
The HELP command displays help text for the NCI commands that are supported in the current
operating mode. See Appendix A (page 71) for descriptions of the NCI commands.
Syntax
HELP [command-name]
88 NCI Commands