Modifying Access Paths › Modifying Access Path Details › Specifying Select/Omit Criteria

Specifying Select/Omit Criteria

CA 2E allows you to specify select/omit criteria that filter your view of the records for the RTV, RSQ, SPN, and QRY type access paths.

For more information about select/omit criteria, see the section Choosing Select/Omit Criteria in this chapter.

Specify select/omit criteria. At the Edit Access Path Details panel, enter or change the select/omit criteria at the Allow Select/Omit field and press Enter.

Options are:

• S—Static applies the selection and omission criteria as the records are added (stored)
• D—Dynamic specifies the selection and omission of logical file records performed during processing, instead of when the access path (if any) is maintained
• Blank—No selection/omission criteria

Note: Dynamic must be specified if there are any virtual fields on the access paths. For QRY access paths, dynamic will be defaulted if required.