EasyManua.ls Logo

HP NonStop SQL/MP

HP NonStop SQL/MP
331 pages
To Next Page IconTo Next Page
To Next Page IconTo Next Page
To Previous Page IconTo Previous Page
To Previous Page IconTo Previous Page
Loading...
Dynamic SQL Operations
HP NonStop SQL/MP Programming Manual for C429847-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.

Table of Contents

Related product manuals