Introduction to Access Paths › Recognizing the Basic Properties of Access Paths › Resequence (RSQ) Access Path

Resequence (RSQ) Access Path

A RSQ access path specifies a uniquely or non-uniquely keyed, single-format access path you can use to describe to CA 2E functions how records are to be retrieved from a file. This access path type:

• Must be created explicitly
• Defaults to those keys defined by the key relations for the based-on file, but allows them to be overridden to an alternative key sequence that does not need to be unique
• Allows virtual fields to be specified on the access path
• Is associated with a RTV access path that points to an associated UPD access path
• Defaults to the virtual fields of the based-on file's relations. These are then present on the access path's relations

You can create many RSQ access paths for a given file. Each can contain a different combination of data fields and/or virtual fields, a different set of selection criteria, or an alternative key order.