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

struct {
    short       sqlnz;         /* Effective array count */
    struct {
      struct {
        short   sqlchemal;     /* Effective authorization identifier length */
        char    sqlschemac[8]; /* Authorization identifier storage area */
     } sqlschema;
      struct {
        short   sqltypel;      /* Effective length of user-defined type
                                                                            name */
        char    sqltypec[30];  /* User-defined type name storage area */
    } sqltnvar[n];1
} Usrsqltnda;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 (usrsqltnda portion), except that a character string beginning with SQL cannot be specified. When the Type Name Descriptor Area is specified using a DESCRIBE statement, the name of the allocated area must be specified.

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

01  USQLTNDA.1
  02  USQLTZ  PIC  S9(4) COMP.
  02  USQLTNVAR  OCCURS  1  TIMES  n.2
    03  USQLSCHEMA.
      04  USQLSCHEMAL  PIC  S9(4)  COMP.
      04  USQLSCHEMAC  PIC  X(8).
    03  USQLTYPE.
      04  USQLTYPEL  PIC  S9(4)  COMP.
      04  USQLTYPEC  PIC  X(30).

¹ Any name can be specified as the name of the set item (USQLTNDA portion); however, a character string that begins with SQL cannot be used for a data item.

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