Table Procedure Examples, Design, and Use › Access Methods for Selected Records › Use Unique Keys to Access Records on the Primary Path › Plural Access

Plural Access

Plural access returns all occurrences of a particular record type to the SQL engine for the current owner occurrence. To satisfy this requirement, table procedures generated by Quick Bridge sequentially process the record type based on its position in the primary path. Entry records that:

• Are members of a mandatory/automatic system-owned index are accessed using that index to find all its member records.
• Do not participate in a mandatory/automatic system-owned index are accessed by performing an area sweep until all record occurrences for that record type are found.

For path records, the set relationship is used to return all members for the current owner occurrence. Target records that are linked with the path through a SET which is not automatic, will always be accessed using an area sweep.