Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - Programming » SQL Anywhere Data Access APIs » SQL Anywhere embedded SQL » The SQL descriptor area (SQLDA)


SQLDA sqllen field values

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