Progress
Embedded SQL-92
Guide and Reference


SQL Descriptor Area (SQLDA)

The SQL Descriptor Area (SQLDA) is a storage area for descriptive information about a dynamic SQL statement. An SQLDA can be used while passing parameter values for executing a dynamic SQL statement and while retrieving results of a dynamic SELECT statement.

Dynamic SELECT statements must be executed differently from non-SELECT statements, since they return information and data beyond the scope of the SQLCA. A program executing a dynamic SELECT statement must determine the lengths and types of values being returned.

Similarly, a program executing a dynamic statement that is a non-SELECT statement must know the input values supplied to the parameters referenced in the statement.

For both categories of statements, determine the required value with a DESCRIBE statement. The DESCRIBE statement obtains information about a prepared statement. For more information on the DESCRIBE statement, see the "DESCRIBE Statement" section.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095