Modifying Access Paths › Choosing Select/Omit Criteria › Specifying Selection

Specifying Selection

Use the Edit Access Path Select/Omit panel to specify selection and the names of the select/omit sets that make up the selection criteria. The following steps tell you how to specify selection.

1. Zoom into the file.

   At the Edit Database Relations panel, type Z next to any relation for the selected file and press Enter. Alternatively, you can use selection option 2 from the Edit Model Object List panel.

   The Edit File Details panel displays.

2. Zoom into the access path.

   Type Z next to the selected access path and press Enter.

   The Edit Access Path Details panel displays.

3. Select the format.

   Enter S next to the selected format and press Enter.

   The Edit Access Path Select/Omit panel displays.

   Note: The Allow Select/Omit access path option must be set to either
   S or D.

4. Specify selection.

   Type S for select or O for omit in the S/O column and the text description to indicate the name for the selection criteria set.

   

5. Zoom into the selection.

   Type Z next to the selection to specify the conditions and press Enter.

   The Edit Access Path Conditions panel displays.