The following code shows the format of the Column Name Descriptor Area that is to be expanded in the source program when C language is used:

struct {
    short        sqlnz;        /* Effective arrays count  */
    struct {
        short    sqlnamel;     /* Effective column name length */
        char     sqlnamec[30]; /* Column name storage area   */
    } SQLNAME[n];1
  }XXXXX;2

¹ n indicates the same number (1-30000) as the size of the SQLVAR array in the SQL Descriptor Area.

² Any desired character string can be specified as the structure name (XXXXX portion), except that a character string beginning with SQL cannot be specified. When Column Name Descriptor Areas are specified using a DESCRIBE statement, the name of the allocated areas must be specified.

The following code shows the format of the Column Name Descriptor Area that is to be expanded in the source program when COBOL is used:

01  SQLCNDA. 1
  02  SQLNZ  PIC  S9(4) COMP.
  02  SQLNAME  OCCURS  1  TIMES  n. 2
    03  SQLNAMEL  PIC  S9(4)  COMP.
    03  SQLNAMEC  PIC  X(30).

¹ Any name can be specified as the name of the set item (SQLCNDA area); however, a character string that begins with SQL cannot be used for a data item. In addition, the set item level must always be set to 01.

² n indicates the required number (1-30000).