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

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 LockDisk Process
Accessed Used I/Os Count Bytes Escl WaitBusy 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.
Examples
• This command causes the local time to be displayed in the SQL prompt:
SQL>set time on
14:17:17 SQL>
• This command causes the local time to be displayed in 12–hour AM/PM style in the SQL
prompt:
SQL>set time on 12h
2:17:17 PM SQL>
• This command turns off the local time in the SQL prompt:
130 NCI Commands