HP 3000 Manuals

ALLBASE/SQL Release F.0 Application Programming Bulletin for MPE/iX

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.

MPE/iX 5.0 Documentation