Concepts › CA IDMS Extractor Database Paths › Record Level Selection Criteria

Record Level Selection Criteria

Record Level Selection Criteria define what record occurrences in the source database are going to be extracted. The Criteria is maintained by set type and must be specified for each owner and member record of all sets selected in a path definition. If a record type is retrieved by two different sets, two sets of record level selection criteria must be specified.

For example, in Example Data Structure Diagram, IX-SUBJ-LNAME is selected as an entry index, the PREREQSFOR set is selected walking from owner to member, and the PREREQSARE set is selected walking member to owner. The SUBJECT record is retrieved twice in this path definition: once as member of the Entry Index and once as owner of the PREREQSARE set. Therefore, Record Level Selection Criteria must be defined for the SUBJECT record both as a member of the Entry Index and as owner of the PREREQSARE set. Thus, the Record Level Selection Criteria for the SUBJECT record as it is retrieved as a member of the entry index can be different than the Record Level Selection Criteria for the SUBJECT as it is retrieved as owner of the PREREQSARE set.

Records can be selected from the source database in a variety of ways. Refer to the example of Sample Record Level Selection Criteria Screen.

• Direct DBKEY--Extract the record occurrence with the DBKEY specified by the page/line fields. If you do not want to use Field Level Selection Criteria, use Direct DBKEY to select an OOAK Entry Record or to select a record containing specific values in a particular field.
• Limit Page Range--Limits the extraction of record occurrences to the page range specified by the from/to page numbers.
• Limit Records of This Type--Limit the number of record occurrences extracted from the source database by:
  • Total number of record occurrences that you want CA IDMS Extractor to extract from the source database. This value is the maximum number of record occurrences that CA IDMS Extractor extracts for the record type.
  • Maximum number of record occurrences that CA IDMS Extractor extracts for each set occurrence in which the record participates as a member.
• Skip Between Records--Bypasses the number of record occurrences specified by the skip count record type. For example, to extract every fifth record occurrence on the source database, specify a Skip Count of "4".
• Specify First Within Range--Tells CA IDMS Extractor to extract the first occurrence of a record type accessed within a record's specified range. For a CALC record that is a member of a set being walked, the first occurrence retrieved may NOT be the first physical occurrence in the range.
• Field values tell CA IDMS Extractor to compare field data in record occurrences to entered Field Level Selection Criteria. You may indicate that a record is to be extracted if the data in the record occurrence is:
  • Equal
  • Not Equal
  • Less Than
  • Less Than or Equal
  • Greater Than
  • Greater Than or Equal

  to the data you specify, or:

  • Within
  • Not Within

  a range of values you specify.