Previous Topic: Identifying Access Path Format TextNext Topic: Changing the Key Sequence

Modifying Access Paths › Modifying Access Path Format Entries › Identifying Access Path Format Keys

Identifying Access Path Format Keys

The keys of UPD and RTV access paths come from the key relations for the based-on file and cannot be changed.

The keys of the RSQ, SPN, and QRY type access paths are initially defaulted to the entries defined by the key relations but can be changed. Keys can be sequenced in ascending or descending order.

For more information about the i OS limit on the number of keys that can be specified, see IBM i Database Guide.

If an alternative collating table is specified for the access path, you can specify whether to use it to collate particular key fields. You can use this panel to flag those keys that are to be alternately collated.