SQL/MX Remote Conversational Interface (RMXCI) Guide for SQL/MX Release 3.1 (H06.23+, J06.12+)
Example
The following command shows that the SQL terminator for the current session is a period (.):
SQL>show sqlterminator
SQLTERMINATOR .
For more information, see “Setting and showing the SQL terminator” (page 36).
SHOW STATISTICS command
The show statistics command displays whether statistics are enabled or disabled for the
current session.
Syntax
SHOW STATISTICS
Considerations
• You must enter the command in one line.
• If the set timing command is set to on, the elapsed time information appears.
Example
The following commands show show statistics disabling and enabling:
SQL>show statistics
STATISTICS OFF
SQL>set statistics on
SQL>show statistics
STATISTICS ON
SHOW TABLES command
The show tables command displays all or a set of tables that exist in the current catalog and
schema for the RMXCI session.
Syntax
SHOW TABLES [wild-card-pattern]
wild-card-pattern
is a character string used to search for and display tables with names that match the character
string. wild-card-pattern matches an uppercase string unless you enclose it within double
quotes. To look for similar values, specify only part of the characters of wild-card-pattern
combined with these wild-card characters:
Use a percent sign (%) to indicate zero or more characters of any type. For example, %art% matches
SMART, ARTIFICIAL, and PARTICULAR but not smart or Hearts. "%art%" matches smart and
Hearts but not SMART, ARTIFICIAL, or PARTICULAR.
%
Use an asterisk (*) to indicate zero or more characters of any type. For example, *art* matches SMART,
ARTIFICIAL, and PARTICULAR but not smart or Hearts. "*art*" matches smart and Hearts
but not SMART, ARTIFICIAL, or PARTICULAR.
*
Use an underscore (_) to indicate any single character. For example, boo_ matches BOOK and BOOT
but not BOO or BOOTS. "boo_" matches book and boot but not boo or boots.
_
Use a question mark (?) to indicate any single character. For example, boo? matches BOOK and BOOT
but not BOO or BOOTS. "boo?" matches book and boot but not boo or boots.
?
112 RMXCI commands