SQL/MX Report Writer Guide

Using MXCI and the Report Writer
HP NonStop SQL/MX Report Writer Guide—527194-002
2-3
The Elements of Your Session Environment
The catalog and schema you have set are in effect until the end of your session or until
you execute another SET CATALOG or SET SCHEMA command.
The Elements of Your Session Environment
Note. All examples in this guide assume that you have already set the correct names for the
catalog and schema, as appropriate, at the beginning of your session.
CURRENT DIRECTORY Path name of the current server directory.
It can be changed by using the cd command.
HOME DIRECTORY The default directory.
LIST_COUNT Current setting of this session option.
LOG FILE File to which MXCI logs your session activity. MXCI writes the
commands you enter and the output produced by the commands to
the log file. For example, a SELECT command and the rows
selected by the command are written to the log file. You specify the
log file in a LOG command. You can request that only commands be
logged.
MESSAGEFILE Name of the current SQL/MX message file.
MESSAGEFILE LANG Language of the text in the message file.
MESSAGEFILE VRSN The version of SQL/MX software in use.
SQL CATALOG The current default catalog name.
SQL SCHEMA The current default schema name.
TRANSACTION ID The transaction identifier of the current TMF transaction, if one is in
progress.
TRANSACTION STATE Transaction status:
•
in progress — a TMF transaction has been initiated
•
not in progress — no transaction has been initiated since
any previous transaction was committed or aborted.
WARNINGS Current setting for warnings:
•
On
•
Off