CA Culprit in the CA IDMS/DB Environment › SELECT / BYPASS Parameters › What They Do

What They Do

The SELECT/BYPASS parameters specify selection criteria that are applied to each input record; if the input record meets the selection criteria, it is processed in the CA Culprit run.

SELECT/BYPASS parameters apply selection criteria to different record types, as follows:

• SELECT/BYPASS parameters select records in a sequential file that is defined on the KEYFILE parameter.
• SELECT/BYPASS parameters limit unnecessary database record retrieval. If a database record occurrence does not meet the selection criteria specified on the SELECT/BYPASS parameters, CA Culprit does not continue to navigate the path defined on the PATH parameter.
• SELECT/BYPASS parameters select rows from a table. For example, if a table contains rows of information for all departments in a company, the SELECT or BYPASS parameter selects rows of information to be processed for specified departments.
• SELECT/BYPASS parameters apply selection criteria to the completed input buffer.

More than one SELECT or BYPASS parameter can be coded for each entity; however, both SELECT and BYPASS parameters cannot be applied to the same parameter or buffer.

Since SELECT or BYPASS parameters can apply selection criteria to different parameter types and to the input buffer, placement of SELECT/BYPASS parameters in the input stream is significant.

Considerations

• SELECT/BYPASS parameters should immediately follow their associated KEYFILE or PATH parameters.
• If SELECT/BYPASS parameters do not immediately follow their associated KEYFILE and PATH parameters in a database access run, SELECT/BYPASS selection criteria is applied to all preceding PATH parameters or to the KEYFILE parameter last encountered.
• SELECT/BYPASS parameters that specify the BUFFER option must follow any INPUT, KEYFILE, and PATH parameters specified for the CA Culprit run.

Listings

The Input Parameter Listing and Run Time Message listing provide information about CA Culprit's interpretation of selection criteria and the actual number of records tested. The following figure illustrates both listings. The Input Parameter Listing assigns a reference number to each selection operation. The reference number appears again in Run Time Messages under the Selection Specification Statistics, which indicate how many records were tested and how many passed or failed the test. The CA IDMS/DB Database Extract Statistics in the same listing indicate how many strings were returned for a specific path and how many of these strings were not processed due to selection criteria.

 mm/dd/yy           INPUT PARAMETER LISTING      Vnn.n         PAGE    1

 ********
 SEL/BYP  REF       CONDITION
 ********
  SEL             $     DEPARTMENT IN PATH AA WHEN DEPT-ID-0410 EQ (5100 3200)  ─┐
  SEL    00001      DEPT-ID-0410        EQ        5100                           │
  SEL    00002      DEPT-ID-0410        EQ        3200                           ├─ CA-Culprit's interpretation
  SEL             $     EMPLOYEE IN PATH DD WHEN EMP-ID-0415 EQ (0301 0054 0074) │  of selection criteria
  SEL    00003      EMP-ID-0415         EQ        0301                           │
  SEL    00004      EMP-ID-0415         EQ        0054                           │
  SEL    00005      EMP-ID-0415         EQ        0074                          ─┘
 mm/dd/yy           RUN TIME MESSAGES          Vnn.n        PAGE     1
   IDMS DATABASE EXTRACT STATISTICS                   ─┐
   STRINGS RETURNED FOR PATH AA -          15          ├─ Number of strings CA-Culprit
   STRINGS TRUNCATED BY SELECTION CRITERIA         24  │  returned for each path and
   STRINGS RETURNED FOR PATH BB -          24          │  bypassed due to selection
   STRINGS RETURNED FOR PATH CC -           0          │  criteria
   STRINGS RETURNED FOR PATH DD -           5          │
   STRINGS TRUNCATED BY SELECTION CRITERIA         83 ─┘
   STRINGS RETURNED FOR PATH EE -           0
   RECORD NAME       NUMBER READ
  DEPARTMENT                  26
  EMPLOYEE                    85
  OFFICE                      15
  COVERAGE                     5
 ***********  END OF FILE  ******************************************************
           44 INPUT RECORDS READ
          SELECTION SPECIFICATION STATISTICS
          BEGINNING      TIMES      TIMES      TIMES    NUMERIC  SUBSCRIPT  ─┐
          REFERENCE     TESTED       TRUE      FALSE     ERRORS     ERRORS   │
           NUMBER                                                            ├─ Number of strings tested by
                                                                             │  the selection criteria
               1            26          2         24          0          0   │
               3            85          2         83          0          0  ─┘

Note: The Input Parameter Listing interprets and assigns a reference number to each SELECT/BYPASS statement. The Run Time Messages listing indicates how many strings were processed for each path and the number of times each SELECT/BYPASS statement was tested.

More information:

CA Culprit in the CA IDMS/DB Environment

About the KEYFILE Parameter