SQL/MX 2.x Reference Manual (H06.04+)

MXCI Commands
HP NonStop SQL/MX Reference Manual—540440-003
4-59
SHOW SESSION Command
SHOW SESSION Command
Examples of SHOW SESSION
SHOW SESSION displays attributes of the current MXCI session. You can use SHOW
SESSION (or ENV) only within an MXCI session.
SHOW SESSION displays these attributes:
SHOW SESSION
CURRENT DIRECTORY Path name of the current server directory. You can use the CD
command to change it.
HOME DIRECTORY Default directory.
LIST_COUNT Current list count.
LOG FILE Current log file.
MESSAGEFILE Current message file.
TERMINAL_CHARSET Current character set for the session.
MESSAGEFILE LANG Language of the text in the message file.
MESSAGEFILE VRSN Version of the message file; its value is stored in the message.
SQL CATALOG Default catalog.
SQL SCHEMA Default schema.
TRANSACTION ID Transaction identifier of the current transaction if one is in
progress.
TRANSACTION STATE Transaction status (in progress or not in progress).
WARNINGS Current state of warnings (on or off).