SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
E-3
END DECLARE SECTION Directive
END DECLARE SECTION Directive
END DECLARE SECTION is a host program directive that ends a host program
Declare Section for declaring host variables to use in SQL statements.
For more information about declaring host variables, see the SQL/MP programming
manual for your host language.
Example—END DECLARE SECTION
This 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

These are the fields in the ENV display:
END DECLARE SECTION
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 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).