ASA Programming Guide
Embedded SQL Programming
The SQL descriptor area (SQLDA)
The sqllen field length of the sqlvar structure in a SQLDA is used in the following kinds of interactions with the database server:
describing values The DESCRIBE statement gets information about the host variables required to store data retrieved from the database, or host variables required to pass data to the database.
See Describing values.
retrieving values Retrieving values from the database.
See Retrieving values.
sending values Sending information to the database.
See Sending values.
These interactions are described in this section.
The following tables detail each of these interactions. These tables list the interface constant types (the DT_ types) found in the sqldef.h header file. These constants would be placed in the SQLDA sqltype field.
For information about sqltype field values, see Embedded SQL data types.
In static SQL, a SQLDA is still used but it is generated and completely filled in by the SQL preprocessor. In this static case, the tables give the correspondence between the static C language host variable types and the interface constants.
Describing values
Sending values
Retrieving values