Table Procedure Examples, Design, and Use › Access Methods for Selected Records › Unique Access Strategies for Entry, Path, and Auxiliary Records[ › Unique Access Methods for Auxiliary Records

Unique Access Methods for Auxiliary Records

An auxiliary record is a record that participates in a set relationship with the target record, but is not part of the primary path. The generated table procedure locates unique occurrences of auxiliary records in one of two ways:

• In Next Row processing, each auxiliary record is located as owner in the auxiliary relationship. The query returns the auxiliary record's unique key to the SQL engine for filtering.
• In Insert Row and Update Row processing (when the foreign key is changed), the auxiliary record is located by one of four ways.
  • CALC access mode — When the unique keys fields selected in Quick Bridge match the CALC key fields exactly, the record type uses CALC access mode
  • INDEX SET USING access method — When the auxiliary record is a member of a system-owned index and the unique key fields selected in Quick Bridge match the index key fields exactly, the INDEX SET USING access mode is being used. The INDEX SET USING access mode requires that the unique key fields, that make up the index, are specified in the same order as the sort elements of the index set are defined in the network schema.
  • Indexed access — When the auxiliary record is a member of a mandatory/automatic system-owned index, CA IDMS compares all record occurrences in that index to the values passed to the table procedure. The single unique record occurrence with that key becomes the object of the new or updated set relationship.
  • Area sweep — When the auxiliary record cannot be accessed by one of the above methods, each record occurrence for that record type in the area is compared to the values passed to the table procedure. The single unique record occurrence with that key becomes the object of the new or updated set relationship.