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

Sample Record Level Selection Criteria Screen

CA─IDMS/DBX Rnn.nn ───  Record Level Selection Criteria ─────── hh:mm mm/dd/yy
COMMAND ===>

Entry Record: CRITERIA
Path Record:  CRITERIA          From Page:     370000
To Page:     372999
Accessed By:  AREA SWEEP   of area      USV-DATA-AREA
Enter S to Select, D or blank to Deselect selection criteria,
press ENTER.
Note: The specification is currently not complete.
      Direct DBKEY              Page ===> 0000000000 Line ===> 0000
      Limit Page Range     From Page ===> 0000370000 To Page ===> 0000372999
    S Limit Records of This Type          Total Record Count ===> 0000000050
                                          Per Set Occurrence ===> 0000000000
      Skip Between Records                Skip Count         ===> 0000000000
      First Within Range
      Nth   Within Range                  Which Occurrence   ===> 0000000000
      Field Level Selection Criteria      Display Criteria?  ===> Y  (Y/N)
      Logical Key Selection Criteria      Display Criteria?  ===> Y  (Y/N)
      Retain Physical Sequence of Member Records in the Set? ===> Y  (Y/N)
      Extract All Owners of Extracted Recursive Records?     ===> Y  (Y/N)
      Number of Levels to Extract in the Recursive Structure ===> 00000000

• In a situation where a record is retrieved by two different sets, you must tell CA IDMS Extractor how many levels of the recursive structure are to be extracted.

  Using the same example shown in Sample Record Level Selection Criteria Screen, where the 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 as owner of the PREREQSARE set would be retrieved a second time. You need to tell CA IDMS Extractor how many occurrences of the SUBJECT record are to be retrieved, as owner of the PREREQSARE set, after each occurrence of the SUBJECT is retrieved by the Entry Index.

  A more detailed discussion of extracting from recursive structures is presented below.

• When a selected set is accessed by walking from member to owner and the set is a non-sorted set, CA IDMS Extractor must perform an OBTAIN NEXT IN SET until end of set in order to keep the logical integrity of the set intact. For extremely large sets, this walking may impose a tremendous amount of overhead. An option is provided to have CA IDMS Extractor perform an OBTAIN OWNER in the set if you do not require CA IDMS Extractor to maintain logical set integrity for the member records.