MX Release 3.1 (H06.23+, J06.12+)

SHOW ALIAS command

The show alias command displays all or a set of aliases available in the current RMXCI session.

If a pattern is specified, all aliases matching the pattern are displayed. By default, all aliases in

the current session are displayed.

Syntax

SHOW ALIAS [alias-name | wild-card-pattern]

alias-name

is any alias name that is used with the ALIAS command. See “ALIAS command” (page 58).

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 ALIAS command 99