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

Syntax
SHOW PARAM [param name]
Considerations
• You must enter the command in one line.
• If the set timing command is set to on, the elapsed time information appears.
• The command does not accept wildcard in param name.
Example
• The following command shows the parameters that are set for the current session:
SQL>show param
lastname GREEN
dn 1500
sal 40000.00
• The following command shows that an error message is returned by the show param command
when there are no parameters found:
SQL>show param
*** ERROR[29428] No parameters found.
• The following command shows the existing param, dn:
SQL>show param dn
dn 1500
For more information, see “Displaying the parameters for the session” (page 63).
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.
128 RMXCI commands