Nonstop Database, HiRDB Version 9 UAP Development Guide
The Column Name Descriptor Area is allocated as static area by declaring it in the UAP.
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
#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 (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).
#1: 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.
#2: n indicates the required number (1 to 30,000).
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.