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

Considerations
• You must enter the command in one line.
• The env command displays the following attributes:
Current column separator, which controls the display of query results. For
more information, see “SET COLSEP command” (page 107).
COLSEP
Name of the data source, which 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 control how the commands are added to
the history buffer. For more information, see “SET HISTOPT command”
(page 108).
HISTOPT
Current idle timeout value, which controls the timeout value for an inactive
session. By default, the idle timeout is 30 minutes. For more information,
IDLETIMEOUT
see “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 the directory containing the log file. By default, logging
during a session is turned off. For more information, see “Logging output”
LOG
(page 66) and “LOG command” (page 94) or “SPOOL command”
(page 138).
Current look-and-feel of 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
Current markup option selected for the session. The default option is RAW.
For more information, see “SET MARKUP command” (page 111).
MARKUP
Current catalog. The default is NONSTOP_SYSTEM_NSK.CATALOG
Current prompt for the session. In SQL mode, the default is SQL>. For more
information, see “Customizing the standard prompt” (page 56) and “SET
PROMPT command” (page 116).
PROMPT
Current schema. The default is
NONSTOP_SYSTEM_NSK.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 setting (on or off) of statistics. For more information about statistics,
see the SQL/MX Release 3.x Reference Manual.
STATISTICS
Current setting (on or off) of the local time as part of the prompt. When
this command is set to on, military time appears. By default, the local time
is off. For more information, see “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
84 RMXCI commands