Modifying Access Paths › Choosing Select/Omit Criteria

Choosing Select/Omit Criteria

This topic provides instructions about how to specify selection and conditions.

Access path selection lets you specify that a particular access path retrieves only the records from the file that meet specified select/omit criteria, such as those that contain specified values for particular fields.

For example, you have a personnel file containing records for both full-time and part-time employees. If you want to obtain a view of only the part-time employees, you can define an access path with selection on an employee type field that identifies part-time employees.