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

SQL> show aliases
.OS AS LH
.GOTO AS GOTO
USE AS SET SCHEMA
SHOW CATALOG command
The show catalog command displays the current catalog.
Syntax
SHOW CATALOG
Considerations
You must enter the command in one line.
Examples
The following command displays the current catalog:
SQL> set catalog cat11
--- SQL operation complete.
SQL> show catalog
CATALOG CAT11
SHOW CATALOGS command
The show catalogs command displays all the catalogs in the database, to which the RMXCI
session is connected .
Syntax
SHOW CATALOGS [wild-card-pattern]
wild-card-pattern
is a character string used to search for and display schemas 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.
?
Considerations
You must enter the command in one line.
SHOW CATALOG command 123