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

Examples
The following command displays all the catalogs:
SQL> set catalog cat11
--- SQL operation complete.
SQL> show catalogs
SQL>
SQL> CATALOG NAMES
-----------------------------------------------------------------------------
ACCMXCAT
CAT
CAT1
CAT11
The following command lists all the catalog names starting with the letter C.
SQL> show catalogs C*
SQL>
SQL> CATALOG NAMES
-----------------------------------------------------------------------------
CAT
CAT1
CAT11
SHOW COLSEP command
The show colsep command displays the value of the column separator for the current RMXCI
session.
Syntax
SHOW COLSEP
Considerations
• You must enter the command in one line.
• If the set timing command is set to on, the elapsed time information appears.
Examples
• The following command displays the column separator:
SQL> show colsep
COLSEP " "
SQL> set colsep *
SQL> show colsep
COLSEP "*"
SHOW ERRORCODE command
The show errorcode command is an alias for the show lasterror command. For more
information, see “SHOW LASTERROR command” (page 126).
Syntax
SHOW ERRORCODE
Examples
The following command displays the error returned from the execution of the last SQL statement :
124 RMXCI commands