Modifying Access Paths › Modifying Access Path Format Entries › Editing Access Path Format Entries

Editing Access Path Format Entries

The presence of a field on an access path format (an access path entry) is controlled by the relations specified for the access path. By default, all the relations specified for the based-on file are declared to be present on an access path so that all the fields from the file are initially present. By dropping particular relations from an access path, you can omit fields from the access path's format.

To display and change the relations for an access path, use the Edit Access Path Relations panel. To display the fields that are present on the access path format, use the Edit Access Path Format Entries panel.

You can use the Edit Access Path Format Entries panel to specify an alternative key order for RSQ, QRY, and SPN type access paths. CA 2E lets you edit access path format entries using the Edit Access Path Details panel. Access path formats are created automatically for all access path types except SPN. For SPN access paths you need to add formats explicitly.

For more information on adding SPN access path format entries, see this guide's "Adding Access Paths" chapter.

Note: Relations are present on an access path if they were added to the based-on file after a hold was specified on the access path.