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.
[vellip]
EXEC SQL END DECLARE SECTION END-EXEC.
|