SQL Programming Manual for Pascal

Error and Status Processing
HP NonStop SQL Programming Manual for Pascal—528614-001
6-17
Declaring the SQLDA and Names Buffer
Table 6-4. SQLDA Fields (page 1 of 2)
Field Name Description
SQLDA_EYE_CATCHER Constant declared by the system. If you requested an
SQLDA release option that is different from the release of the
SQL compiler, SQLDA_EYE_CATCHER appears as either
SQLDA_EYE_CATCHER_1_R1 or
SQLDA_EYE_CATCHER_R2.
sqlda_type Type definition for the SQLDA structure. If you requested an
SQLDA release option that is different from the release of the
SQL compiler, SQLDA_TYPE appears as either
SQLDA_TYPE_R1 or SQLDA_TYPE_R2.
eye_catcher Identifying field your program initializes with the system-
declared constant SQLDA_EYE_CATCHER. SQL
statements do not return values to EYE_CATCHER. See the
notes following this table for information on initializing this
field.
num_entries Number of input parameters or database columns this
SQLDA structure can accommodate. If your program used
INCLUDE SQLDA, num_entries gives the number you
specified for sqlvar_count. If your program allocated the
SQLDA dynamically, the program must fill in num_entries.
sqlvar Descriptions for input parameters or database columns.
DESCRIBE INPUT and DESCRIBE return an sqlvar item for
each parameter or database column.
sqlvar_type Type definition for sqlvar structure. If you requested an
SQLDA release option that is different from the release of the
SQL compiler, sqlvar_type appears as either
SQLVAR_TYPE_R1 or SQLVAR_TYPE_R2.
data_type Data type of the parameter or column.
data_len Information depending on data type as follows:
For a fixed-length character string, contains the number
of characters in the string
For a variable-length character string, contains the
maximum number of characters allowed in the string
(not including the two bytes of length).
scale Decimal scale for a binary or decimal numeric item.
nlen Length of a binary or decimal numeric item.
dt_qualifier* Range of date-time or INTERVAL fields for a DATETIME or
INTERVAL column; contains a code for the range of fields.
Literals for these codes are described in the table Data Type
Values and Literal Declarations on page 6-19.
dt_len* Length of a date-time or INTERVAL item in bytes.
precision* Precision for a date-time or INTERVAL column.
lead_field_precision* Leading field precision for a date-time or INTERVAL column.