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 |