The SQL Descriptor Area (SQLDA)

The SQLDA (SQL Descriptor Area) is an interface structure that is used for dynamic SQL statements. The structure is used to pass information regarding host variables and SELECT statement results to and from the database. The SQLDA is defined in the header file sqlda.h.

There are functions in the database interface shared library or DLL that you can use to manage SQLDAs.

When host variables are used with static SQL statements, the preprocessor constructs a SQLDA for those host variables. It is this SQLDA that is actually passed to and from the database server.

• The SQLDA Header File
  The contents of sqlda.h are as follows:
• SQLDA Fields
  The SQLDA fields have the following meanings:
• SQLDA Host Variable Descriptions
  Each sqlvar structure in the SQLDA describes a host variable. The fields of the sqlvar structure have the following meanings:
• SQLDA sqllen Field Values
  SQLDA sqllen field values after a DESCRIBE, when sending values, and when retrieving data.