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

DEMOSCH1 DEMOSCH2 DEMO_SCH
DEV060525 DS_SCH D_SALES
HMGR HPNVS HPNVSSCH
HPNVS_SAMPLE HPNVS_SAMPLE INVENT
ODBC_INVENT ODBC_PERSNL ODBC_SALES
ODBC_SCHEMA ODBC_TEST PERSNL
PUBLIC_ACCESS_SCHEMA ROLEDBA ROLEMGR
ROLEUSER SALES SCH
SERVICES T4JDBC_SCHEMA TEST1
USR
SQL>
• The following command shows the schemas in the default catalog that have SALES in their
names:
SQL>show schemas %sales%
SCHEMA NAMES
------------------------------------------------------------------------
DBSCRIPT_SALES D_SALES ODBC_SALES
SALES
SQL>
For more information, see “Showing the schemas” (page 59).
SHOW SESSION command
The show session or session command displays attributes of the current RMXCI session. You
can also use the env command to perform the same function.
Syntax
[SHOW] SESSION
Considerations
• You must enter the command in one line.
• If the set timing command is set to on, the elapsed time information appears.
• The show session or session displays these attributes:
Current column separator, which is used to control how query results are presented.
For more information, see “SET COLSEP command” (page 107).
COLSEP
Name of the data source that you entered when logging in to the database platform.
For more information, see “Logging in to the database platform” (page 44).
DATASOURCE
Current history options, which controls how the commands are added to the history
buffer. For more information, see “SET HISTOPT command” (page 108).
HISTOPT
Current idle timeout value, which determines when the session expires after a period
of inactivity. By default, the idle timeout is 30 minutes. For more information, see
IDLETIMEOUT
“Setting and showing the idletimeout value for the session” (page 56) and “SET
IDLETIMEOUT command” (page 110).
Current list count, which is the maximum number of rows that can be returned by
SELECT statements. By default, the list count is all rows. For more information, see
“SET LIST_COUNT command” (page 110).
LIST_COUNT
Current log file and directory containing the log file. By default, logging during a
session is turned off. For more information, see “Logging output” (page 66) and
“LOG command” (page 94) or “SPOOL command” (page 138).
LOG
Current look-and-feel type for RMXCI. This property affects the formatting of status
messages. For more information, see “Setting the Look-and-Feel of RMXCI” (page 33).
LOOK AND FEEL
132 RMXCI commands