Nonstop Database, HiRDB Version 9 UAP Development Guide
The Type Name Descriptor Area is allocated by declaring it in the UAP.
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
#1: n indicates the same number (1 to 30000) as the size of the SQLVAR array in the SQL Descriptor Area.
#2: 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).
#1: 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.
#2: n indicates the same number (1 to 30000) as the size of the SQLVAR array in the SQL Descriptor Area.
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.