Record Descriptions For Non-Bulk Queries

Prior to this release, record descriptions were allowed only for host variables referenced in bulk queries. Host variables used in non-bulk queries can now be grouped together into logical records. This facilitates data movement, data initialization, and code readability. Group level identifiers cannot be referenced in non-bulk queries. In the following example, PART-RECORD cannot be referenced in a non-bulk query, but PARTNUMBER can be referenced.

   EXEC SQL BEGIN DECLARE SECTION END-EXEC.

   01  PART-RECORD.

       05  PARTNUMBER                PIC X(16).

       05  PARTNAME                  PIC X(30).

       05  SALESPRICE                PIC S9(8)V99 COMP-3.

       05  SALESPRICEIND             SQLIND.

   .

   .

   EXEC SQL END DECLARE SECTION END-EXEC.