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

CATALOG CAT1
SCHEMA SCH1
SERVER test.acme.com:18650
SQLTERMINATOR ;
STATISTICS OFF
TIME OFF
TIMING OFF
USER sch1.usr
SHOW SQLPROMPT command
The show sqlprompt command displays the value of the SQL prompt for the current RMXCI
session.
Syntax
SHOW SQLPROMPT
Considerations
• You must enter the command in one line.
• If the set timing command is set to on, the elapsed time information appears.
Example
The following command shows that the SQL prompt for the current session is SQL>:
SQL>show sqlprompt
SQLPROMPT SQL>
SHOW SQLTERMINATOR command
The SHOW SQLTERMINATOR command displays the SQL statement terminator for the current RMXCI
session.
Syntax
SHOW SQLTERMINATOR
Considerations
• You must enter the command in one line.
• If the set timing command is set to on, the elapsed time information appears.
Example
The following command shows that the SQL terminator for the current session is a period (.):
SQL>show sqlterminator
SQLTERMINATOR .
For more information, see “Setting and showing the SQL terminator” (page 57).
SHOW STATISTICS command
The show statistics command displays whether statistics are enabled or disabled for the
current session.
134 RMXCI commands