SQL/MX Remote Conversational Interface (RMXCI) Guide for SQL/MX Release 3.1 (H06.23+, J06.12+)
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.
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.
SHOW COLSEP command 101