NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
I-7
Considerations—INCLUDE SQLSA
Considerations—INCLUDE SQLSA
•
Version management considerations
By default, INCLUDE SQLSA declares a version 2 SQLSA. To request a different
version, use INCLUDE STRUCTURES prior to INCLUDE SQLSA.
Examples—INCLUDE SQLSA
•
The following directives declare a version 310 SQLSA in a program:
EXEC SQL INCLUDE STRUCTURES ALL VERSION 310;
EXEC SQL INCLUDE SQLSA;
INCLUDE STRUCTURES Directive
INCLUDE STRUCTURES is a host program or dynamic SQL directive that specifies
the version of the structures generated by the INCLUDE SQLCA, INCLUDE SQLDA,
and INCLUDE SQLSA directives.
version
is an integer that identifies a version of NonStop SQL/MP (1, 2, 300, 310, 315, 320,
325, or 330).
[ ALL ] VERSION version
specifies that any subsequently generated SQLCA, SQLDA, and SQLSA structures
are to have the format for the NonStop SQL/MP version identified by version.
{| SQLCA VERSION version |}
{| SQLDA VERSION version |}
{| SQLSA VERSION version | VERSION CURRENT |}
specifies that any subsequently generated SQLCA, SQLDA, or SQLSA structures
are to have the format for the NonStop SQL/MP version identified by version.
For SQLSA, you can specify either a particular version (by #) or VERSION
CURRENT.
VERSION CURRENT allows C programs to use the most current SQLSA structure
that the current system supports.
{ [ ALL ] VERSION version }
INCLUDE STRUCTURES { }
{ {| SQLCA VERSION version |} }
{ {| SQLDA VERSION version |} }
{ {| SQLSA VERSION
{version | VERSION CURRENT} }