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

SHOW PREPARED command

The show prepared command displays the prepared statements in the current RMXCI session. If

a pattern is specified, all prepared statements matching the prepared statement name pattern are

displayed. By default, all prepared statements in the current session are displayed.

Syntax

SHOW PREPARED [stmtNamePattern]

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 commands show all the prepared statements, by default and, the tables that

match the pattern s% and t%:

SQL>show prepared

select * from s1

select * from student

select * from test123

SQL> show prepared s%

select * from s1

select * from student

SQL> show prepared t%

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

106 RMXCI commands