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

Current markup option selected for the session. The default option is RAW. For more
information, see “SET MARKUP command” (page 111).
MARKUP
Current prompt for the session. The default is SQL>. For more information, see
“Customizing the standard prompt” (page 56) and “SET PROMPT command”
(page 116).
PROMPT
Current catalog for the session. The default is NONSTOP_SYSTEM_NSK. For more
information, see“SET CATALOG command” (page 106) .
CATALOG
Current schema. The default is PUBLIC_ACCESS_SCHEMA. For more information,
see “Setting and showing the current schema” (page 58).
SCHEMA
Host name and port number that you entered when logging in to the database
platform. For more information, see “Logging in to the database platform” (page 44).
SERVER
Current SQL statement terminator. The default is a semicolon (;). For more
information, see “Setting and showing the SQL terminator” (page 57) and “SHOW
SQLTERMINATOR command” (page 134).
SQLTERMINATOR
Current statistics for the session. For more information, see “SET STATISTICS
command” (page 119).
STATISTICS
Current setting (on or off) of the local time as part of the prompt. By default, the
local time is off. For more information, see “Customizing the standard prompt”
(page 56) and “SET TIME command” (page 120).
TIME
Current setting (on or off) of the elapsed time. By default, the elapsed time is off.
For more information, see “Displaying the elapsed time” (page 57) and “SET TIMING
command” (page 120).
TIMING
User name that you entered when logging in to the database platform. For more
information, see “Logging in to the database platform” (page 44).
USER
Examples
• The following command displays the attributes of the current session:
SQL>show session
COLSEP ","
DATASOURCE TDM_Default_DataSource
HISTOPT ALL
IDLETIMEOUT 30 min(s)
LIST_COUNT 0 [All Rows]
LOG OFF
LOOK AND FEEL RMXCI
MARKUP XML
PROMPT SQL>
CATALOG CAT1
SCHEMA SCH
SERVER nsksys.ind.hp.com:18650
SQLTERMINATOR ;
STATISTICS OFF
TIME OFF
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 >
SHOW SESSION command 133