NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
E-3
Examples—END DECLARE SECTION
Examples—END DECLARE SECTION
•
The following statements from a C, Pascal, or TAL program declare host variables
that correspond to the columns of the table PARTS:
EXEC SQL BEGIN DECLARE SECTION;
EXEC SQL INVOKE PARTS AS PARTSREC;
EXEC SQL END DECLARE SECTION;
ENV Command
ENV is an SQLCI command that displays attributes of the current SQLCI session. You
can use ENV at either the SQLCI prompt (>>) or the select-in-progress prompt (S>).
Considerations—ENV
•
ENV display
The following are the fields in the ENV display:
•
Changing attributes displayed by ENV
You can use the CATALOG, LOG, OUT_REPORT, SYSTEM, and VOLUME
commands to change current default values for the SQLCI session. You can change
the OUT file with the OUT command (or with the OUT run option when you start
an SQLCI session).
You can specify a different SQL message file for an SQLCI session by setting the
=_SQL_MSG_node DEFINE before you start the SQLCI session. Changing the
ENV ;
CATALOG The current default catalog.
LANGUAGE The language of text in the message file.
LOG The log file for the SQLCI session.
MESSAGEFILE The current SQL message file.
MESSAGEFILE
VRSN
The version of the NonStop SQL/MP software in use.
OUT The OUT file for the SQLCI session.
OUT_REPORT The OUT_REPORT file for the SQLCI session.
SYSTEM The current default node.
TRANSACTION ID The transaction identifier of the current TMF transaction if
a transaction is in progress.
VOLUME The current default volume.
WORK The TMF transaction status (IN PROGRESS or NOT IN
PROGRESS).