SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
I-5
INCLUDE SQLDA Directive
For more information about the contents and usage of SQLDA, see the SQL/MP
programming manual for your host language.
sqlda-name
is a host identifier that is the name for the SQLDA.
sqlvar-count
is an integer that specifies the maximum number of input parameters (including
indicator parameters) or output columns to be described in the SQLDA at one time.
The default is 1.
(PREPARE returns the number of input or output parameters in a statement to the
INPUT-NUM or OUTPUT-NUM fields of the SQLSA when it compiles the
statement. You can use these values for the corresponding SQLDA
sqlvar-count.)
names-buffer, name-length
declares a names buffer.
names-buffer is the host variable name that is the name for the names buffer.
name-length is the maximum number of bytes in the longest column or
parameter name that is returned to the buffer.
{ RELEASE1 | RELEASE2 }
is an obsolete clause for specifying that the version of the SQLDA should be 1
(RELEASE1) or 2 (RELEASE2). You cannot use this clause if you also use
INCLUDE STRUCTURES. NonStop SQL/MP will not support this clause in the
future, so you should use INCLUDE STRUCTURES to specify the version instead.
CPRULES collation-buffer, collation-size
declares a collation buffer.
collation-buffer is the host variable name that is the name for the collation
buffer.
collation-size is the maximum number of bytes in the largest collation that is
returned to the buffer.
INCLUDE SQLDA ( sqlda-name [, sqlvar-count ]
[ , names-buffer, name-length ]
[ , { RELEASE1 | RELEASE2 } ]
[ , CPRULES collation-buffer, collation-size ] )