SQL/MX Remote Conversational Interface (RMXCI) Guide for SQL/MX Release 3.1 (H06.23+, J06.12+)

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.
• If you do not specify a wildcard pattern, RMXCI displays all procedures that exist in the current
schema.
• If you specify a wildcard pattern, RMXCI displays only the procedure names that match the
wildcard pattern.
• If the set timing command is set to on, the elapsed time information appears.
Examples
The following command shows all the procedures:
SQL>show procedures;
PROCEDURES NAMES
-------------------------------------------------------------------------------------------
ADJUSTSALARY DAILYORDERS EMPLOYEEJOB HELLO
HELLOSTRING LOWERPRICE MONTHLYORDERS MYPROC
N0101 N0122 N0124 N0200
N0202 N0209 N0210 N0211
N0212 N0213 N0216 N0226A
N0302 N4210 N4260 N4261
N4264 N4267
SHOW RECCOUNT command
The show reccount command displays the record count of the previously run SQL statement. If
the previously run command was an interface command, then zero is returned. Otherwise, the
record count of the previously run SQL statement is returned. For a few interfaces that invoke the
catalog API's, like show tables and show views, the command returns the count of the database
objects.
Syntax
SHOW RECCOUNT
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 record count of the SQL statement that was last run :
SHOW RECCOUNT command 107