Modifying Access Paths › Modifying Access Path Relations › Editing Access Path Relations

Editing Access Path Relations

CA 2E lets you display and edit access path relations with the Edit Access Path Relations panel. On this panel, you can reinstate or drop relations from an access path.

1. Zoom into the file.

   From 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 Paths Details panel displays.

3. Select the access path relation.

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

   The Edit Access Path Relations panel displays:

   

4. Specify the access path relations.

   Type + (plus) or - (minus) next to the relations you want to reinstate or remove from the access path and press Enter.

Each access path initially contains all of the relations for the file on which it is based. If a new relation is added to a file, it is added to the list of access path relations for each of the file's access paths except those access paths specified to be held. Held access paths remain unchanged as do any functions attached to them.