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

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 :
SQL> select * From employee;
SQL>show reccount
RECCOUNT 3
SHOW SCHEMA command
The show schema command displays the current schema of the RMXCI session.
Syntax
SHOW SCHEMA
130 RMXCI commands