Dynamic ALLOCATE DESCRIPTOR Statement

The dynamic ALLOCATE DESCRIPTOR statement provides a way to allocate memory for an SQLDA_T structure using Progress/ESQL. The preprocessor generates a call to sqlald() for this statement.

Following is the syntax for the dynamic ALLOCATE DESCRIPTOR statement:

SYNTAX
EXEC SQL ALLOCATE DESCRIPTOR psqlda [ WITH MAX :ncols ]; 

psqlda

The name of a pointer to an SQLDA_T structure.

ncols

The name of a host language integer variable that specifies the number of columns or parameter markers for which you want to allocate the structure. If you do not specify the WITH clause to specify this value, the value 10 is specified as the default.

For an example of an SQLDA_T structure allocation, see Step 4 in the "Executing Dynamic Cursor Specifications" section in this chapter.


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