SQL/MP Programming Manual for C

Dynamic SQL Operations
HP NonStop SQL/MP Programming Manual for C—429847-008
10-4
SQLDA Structure, Names Buffer, and Collation
Buffer
names-buffer
is the SQLDA names buffer; it must follow the conventions for a C identifier.
max-name-length
is the maximum number of bytes you expect in a parameter name or column name
to be returned in a DESCRIBE or DESCRIBE INPUT statement. A qualified column
name can be from 1 to 30 bytes long and is in this format:
table-name.column-name
A parameter name is an SQL identifier with a maximum of 30 bytes.
release-option
specifies the version of the SQLDA structure generated by the C compiler.
RELEASE1 specifies SQL/MP version 1, and RELEASE2 specifies SQL/MP
version 2. If release-option specifies a version other than the default for the
system, the C compiler appends _R1 or _R2 to the SQLDA names and identifiers.
CPRULES
is a required keyword if you specify a collation buffer.
collation-buffer
is a host variable specifying the name of the collation buffer. The
COLLATIONS INTO clause of the DESCRIBE statement allows you to return
collations to collation-buffer.
max-collation-size
is the maximum number of bytes you expect for any one collation.
Note. Although version 300 (and later) C compilers allow the RELEASE1 and RELEASE2
options, HP might not support these options in a future RVU. If you are using a
version 300 (or later) C compiler to generate version 1 or version 2 data structures,
replace the RELEASE1 or RELEASE2 option with the VERSION 1 or VERSION 2 option
of the INCLUDE STRUCTURES directive.