Progress
Embedded SQL-92
Guide and Reference
SQLDA for Output Variables
For a dynamic SQL query, a DESCRIBE statement is required to associate items in the SELECT list with an output SQLDA. You use the DESCRIBE SELECT statement for the OUTPUT SQLDA. This is the syntax for a DESCRIBE SELECT LIST FOR statement:
The DESCRIBE SELECT statement must occur after the PREPARE, DESCRIBE BIND, and OPEN statements, and before the FETCH statement.
EXAMPLEThe following example shows how to use the DESCRIBE SELECT statement:
In this example, the SQLDA is allocated again when the size (first argument) provided in the PRO_SQLDA_Allocate function is insufficient. In this case the SQLDA component SQLD_NVARS contains a negative number equal to the negative of the actual number of outputs.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |