HP NonStop SQL/MP

Error and Status Reporting
HP NonStop SQL/MP Programming Manual for C—429847-008
9-2
Using the INCLUDE STRUCTURES Directive
Use this syntax for the INCLUDE STRUCTURES directive:
ALL VERSION
specifies the same version for all three SQL structures (SQLCA, SQLSA, and
SQLDA).
{ SQLCA | SQLSA | SQLDA } VERSION
specify the SQLCA, SQLSA, or SQLDA structure, respectively.
version
specifies the version number of the generated data structures; version can be 1,
2, 300, or 340 (or later). Version 330 applies only to the SQLSA structure.
SQLSA VERSION CURRENT
specifies that a subsequent INCLUDE SQLSA directive should generate both a
version 300 and version 330 SQLSA structure. This option supports run-time
SQLSA versioning, which allows a program to use an SQLSA structure that has
the same version as the current SQL/MP software for the system.
The SQLSA VERSION CURRENT option has these requirements:

It applies only to the SQLSA structure and not to the SQLCA or SQLDA
structure.

The SQL/MP software version must be 340 or later.

You must compile your program using the NMC compiler on TNS/R systems or
the C compiler with the CPPSOURCE option of the SQL pragma on TNS
systems. For more information, see the C/C++ Programmer’s Guide.

You must include the SQLGETSYSTEMVERSION procedure declaration from
the cextdecs header file in your program, because the option generates a
call to this procedure. For example:
#include <cextdecs (SQLGETSYSTEMVERSION, ...)>
INCLUDE STRUCTURES { structure-spec }
structure-spec is:
{ [ ALL ] VERSION version }
{ { SQLCA | SQLSA | SQLDA } VERSION version }...
{ SQLSA VERSION CURRENT }
{ { SQLCA | SQLSA } [ EXTERNAL ] }