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

Examples
• The following commands show all the prepared statements, by default and, the tables that
match the pattern s% and t%:
SQL>show prepared
S1
select * from s1
S2
select * from student
T1
select * from test123
SQL> show prepared s%
S1
select * from s1
S2
select * from student
SQL> show prepared t%
T1
select * from test123
SHOW PROCEDURES command
The show procedures command displays the procedures (Stored Procedures in Java) in the
current schema of the RMXCI session. If a pattern is specified, all procedures that matches the
pattern are displayed. By default, all procedures in the current schema of the RMXCI session are
displayed.
Syntax
SHOW PROCEDURES [wild-card-pattern]
wild-card-pattern
is a character string used to search for and display procedures 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.
?
SHOW PROCEDURES command 129