Manualshelf

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

ManualsBrandsHP ManualsServerHP Integrity NonStop J-Series
121122123124125126127128129130
wild-card-pattern
is a character string used to search for and display aliases 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.
Examples
The following command displays a list of the available aliases:
SQL>show alias
.OS AS LH
.GOTO AS GOTO
USE AS SET SCHEMA
The following command displays the .GOTO alias:
SQL>show alias .GOTO
.GOTO AS GOTO
The following command output shows that there are no aliases with name .FOO:
SQL>show alias .FOO
No aliases found.
The following command displays all aliases beginning with the letter S:
SQL>show alias S*
SEL AS SELECT
SHOWTIME AS SHOW TIME
ST AS SHOW TABLES
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:
122 RMXCI commands