Extracting roots with nonunique keys
File-AID for IMS/ISPF uses physical DBDs to access the databases during the extract process. Therefore, when retrieving segments to resolve logical relationships, database records for destination parents are retrieved by the database record’s root key and not by the logical path from the logical child to the destination parent.
File-AID for IMS cannot determine which of the roots with the same key to extract in the following situations:
- When the related databases contain roots with nonunique keys, File-AID for IMS extracts all database records with the same root key. This action ensures that the correct database records are extracted and logical relationships are resolved.
- When the primary database contains logical parent segment types, selection criteria are applied and one nonunique root or a child of a nonunique root is selected, File-AID for IMS automatically selects all roots (database records) with the same key. This action ensures that the correct database record is extracted to resolve logical relationships in the primary database.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*