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

MXCI Commands

HP NonStop SQL/MX Reference Manual—540440-003

4-24

ENV Command

ENV displays attributes of the current MXCI session. You can use ENV (or SHOW

SESSION Command) only within an MXCI session.

ENV displays these attributes:

ENV

CURRENT

DIRECTORY

Path name of the current working directory. You can change it with

the CD command.

HOME DIRECTORY Default directory.

LIST_COUNT Current list count.

LOG FILE Current log file.

MESSAGEFILE Current message file.

TERMINAL CHARSET Current character set

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).