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

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 142).
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 57).
SHOW ACTIVITYCOUNT command
The show activitycount command provides an alias for show reccount command. For
more information, see the “SHOW RECCOUNT command” (page 130).
Syntax
SHOW ACTIVITYCOUNT
Examples
The following command shows the record count for the previously run SQL statement:
SQL>show activitycount
ACTIVITYCOUNT 0
SHOW ALIAS command
The show alias command displays all or a set of aliases available in the current RMXCI session.
If a pattern is specified, all aliases matching the pattern are displayed. By default, all aliases in
the current session are displayed.
Syntax
SHOW ALIAS [alias-name | wild-card-pattern]
alias-name
is any alias name that is used with the ALIAS command. See “ALIAS command” (page 80).
SHOW ACTIVITYCOUNT command 121