SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
I-6
Consideration—INCLUDE SQLDA
Consideration—INCLUDE SQLDA
By default, INCLUDE SQLDA declares a version 2 SQLDA. To request a different
version, use INCLUDE STRUCTURES before INCLUDE SQLDA.
The CPRULES clause can be used with SQL/MP versions 300 or later.
Example—INCLUDE SQLDA
This directives declare a version 310 SQLDA in a program:
EXEC SQL INCLUDE STRUCTURES ALL VERSION 310;
EXEC SQL INCLUDE SQLDA;
INCLUDE SQLSA Directive
INCLUDE SQLSA is a host program directive that declares the SQL statistics area
(SQLSA) in a host program.
The SQLSA is an area in which SQL returns statistics about the execution or
preparation of SQL statements. SQL clears the SQLSA before executing each
statement, then returns statistics after the execution of a DELETE, FETCH, INSERT,
OPEN, PREPARE, SELECT, or UPDATE statement. For PREPARE, statistics include
information about input parameters and output columns associated with the dynamic
SQL statement that was prepared.
For more information about the contents and usage of the SQLSA, see the SQL/MP
programming manual for your host language.
Consideration—INCLUDE SQLSA
By default, INCLUDE SQLSA declares a version 2 SQLSA. To request a different
version, use INCLUDE STRUCTURES before INCLUDE SQLSA.
Example—INCLUDE SQLSA
This directives declare a version 310 SQLSA in a program:
EXEC SQL INCLUDE STRUCTURES ALL VERSION 310;
EXEC SQL INCLUDE SQLSA;
INCLUDE SQLSA