Progress
Embedded SQL-92
Guide and Reference
SQLDA for Input Variables
Use an INPUT SQLDA to store the values for input host variables required in an SQL statement. Use a DESCRIBE BIND statement for an input SQLDA.
This is the syntax for a DESCRIBE BIND VARIABLES statement for an INPUT operation:
The DESCRIBE BIND statement must be executed after the PREPARE step and before the OPEN operation.
EXAMPLEThe following example shows how to use a DESCRIBE BIND statement to determine the number of input host variable references in an SQL statement:
In this example, an SQLDA is first allocated for 20 variables. After the DESCRIBE is performed on the prepared statement, the SQLDA is once again allocated for the exact number of host variable references. Note that the second argument for PRO_SQLDA_Allocate( ) is zero when allocating for an INPUT SQLDA.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |