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

Examples
This command shows the default output format as PERTABLE:
SQL>set statistics on
SQL>select * from job;
JOBCODE JOBDESC
------- ------------------
100 MANAGER
1234
450 PROGRAMMER
900 SECRETARY
300 SALESREP
500 ACCOUNTANT
400 SYSTEM ANALYST
250 ASSEMBLER
420 ENGINEER
600 ADMINISTRATOR
200 PRODUCTION SUPV
--- 11 row(s) selected.
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>
For more information on the STATISTICS command, see the Neoview SQL Reference Manual.
SET TIME Command
The SET TIME command causes the local time of the client workstation to be displayed as part
of the interface prompt. By default, the local time is not displayed in the interface prompt.
Syntax
SET TIME { ON[12H] | OFF }
ON
specifies that the local time be displayed as part of the prompt.
OFF
specifies that the local time not be displayed as part of the prompt. OFF is the default.
Considerations
• You must enter the command on one line. The command does not require an SQL terminator.
• The default is a 24-hour military style display. The additional argument of 12h allows the
time to be displayed in a 12–hour AM/PM style.
SET TIME Command 123