Allocates an SQL descriptor area.
An SQL descriptor area is allocated. The SQL descriptor area is used to provide information about variables used for input and output between the application and the database. The
descriptor-nameis identified by a host variable or a literal.
The allocated SQL descriptor area will have as many item descriptor areas as specified by the
WITH MAX occurrencesclause. If
WITH MAX occurrencesis omitted, 100 item descriptor areas are allocated.
The SQL descriptor area has the following structure:
COUNTfield specifies how many item descriptor areas contain data.
See GET DESCRIPTOR for a description of the descriptor fields.
The maximum length of the
descriptor-nameis 128 characters.
The scope of a
descriptor-nameis limited to a single compilation unit and there cannot be more than one descriptor with the same name in a single compilation unit.
Examplemaxcol = 256; exec sql ALLOCATE DESCRIPTOR 'descrOut' WITH MAX :maxcol;
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40