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.
|