SQL/MX Remote Conversational Interface (RMXCI) Guide for SQL/MX Release 3.1 (H06.23+, J06.12+)

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.
Syntax
SET TIMING [ ON | OFF ]
ON
specifies the elapsed time be displayed after each SQL statement is run. For a list of these
statements, see Appendix B (page 119).
OFF
specifies that the elapsed time must not be displayed after each SQL statement is run. OFF is
the default.
Considerations
• You must enter the command in one line.
• The elapsed time value includes compile and execution time along with network I/O time and
client-side processing time.
• If options are not specified, the command selects the default option off.
Examples
• The following command displays the elapsed time for SQL statements:
SQL>set timing on
• The following command turns off displaying the elapsed time:
SQL>set timing off
For more information, see “Displaying the elapsed time” (page 36).
SHOW ACTIVITYCOUNT command
The show activitycount command provides an alias for show reccount command. For
more information, see the “SHOW RECCOUNT command” (page 107).
Syntax
SHOW ACTIVITYCOUNT
Examples
The following command shows the record count for the previously run SQL statement:
SQL>show activitycount
ACTIVITYCOUNT 0
98 RMXCI commands