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

SHOW ALIASES command
The show aliases command displays all the aliases available in the current RMXCI session.
Syntax
SHOW ALIASES
Considerations
You must enter the command in one line.
Examples
The following command displays all the aliases in the current RMXCI session:
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
100 RMXCI commands