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

MXCI Commands
HP NonStop SQL/MX Reference Manual—540440-003
4-25
Examples of ENV
Examples of ENV
•
An ENV command and its output:
>>env;
----------------------------------
Current Environment
----------------------------------
CURRENT DIRECTORY /usr/manager/bin
HOME DIRECTORY /usr/manager
LIST_COUNT 4294967295
LOG FILE
MESSAGEFILE /usr/manager/bin/mxcierrors.cat
TERMINAL CHARSET ISO88591
MESSAGEFILE LANG US English
MESSAGEFILE VRSN {2003-12-11 13:56 NSK:SQUAW/SUPER.SUPER}
SQL CATALOG CAT
SQL SCHEMA SCH
TRANSACTION ID
TRANSACTION STATE not in progress
WARNINGS on
>>
•
An ENV command showing the effect of the NSK NAMETYPE:
>>set nametype NSK;
>>env;
----------------------------------
Current Environment
----------------------------------
CURRENT DIRECTORY /usr/manager/bin
HOME DIRECTORY /usr/manager
LIST_COUNT 4294967295
LOG FILE
MESSAGEFILE /usr/manager/bin/mxcierrors.cat
TERMINAL CHARSET ISO88591
MESSAGEFILE LANG US English
MESSAGEFILE VRSN {2003-12-11 13:56 NSK:SQUAW/SUPER.SUPER}
SQL CATALOG CAT (\SQUAW.$SYSTEM)
SQL SCHEMA SCH (ZSDGTXNC)
TRANSACTION ID
TRANSACTION STATE not in progress
WARNINGS on
>>