SQL/MX Remote Conversational Interface (RMXCI) Guide for SQL/MX Release 3.2 (H06.25+, J06.14+)

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
CAT.TOI.JOB 2 2 0 4 15232 0 0 363
SQL>
For more information on STATISTICS, see the SQL/MX Release 3.x 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 in one line.
• The default is a twenty four–hour military style display. The additional parameter 12h allows
the time to be displayed in a twelve–hour AM/PM style.
Examples
• The following command causes the local time to be displayed in the SQL prompt:
SQL>set time on
14:17:17 SQL>
• The following command causes the local time to be displayed in twelve–hour AM/PM style
in the SQL prompt:
SQL>set time on 12h
2:17:17 PM SQL>
• The following command turns off the local time in the SQL prompt:
2:17:17 PM SQL>set time off
SQL>
SET TIMING command
The set timing command displays the elapsed time after each SQL statement is run. This command
does not display the elapsed time of RMXCI commands. By default, the elapsed time is off.
120 RMXCI commands