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

TIMING OFF
USER sch.usr
• The following command shows the effect of setting various session attributes:
SQL>session
COLSEP " "
DATASOURCE TDM_Default_DataSource
HISTOPT ALL
IDLETIMEOUT 30 min(s)
LIST_COUNT 0 [All Rows]
LOG OFF
LOOK AND FEEL SQLPlus
MARKUP RAW
PROMPT SQL >
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.
SHOW SQLPROMPT command 111