Adding an Access Path

Adding Access Paths › Adding an Access Path

Adding an Access Path

A list of the available types of access paths follows:

Physical (PHY)
Update (UPD)
Retrieval (RTV)
Resequence (RSQ)
Query (QRY)
Span (SPN)

In addition to the three default access path types created when the file is defined, you can create additional update and retrieval access paths or resequence, query, or span access paths using the instructions that follow.

To add any access path, except a PHY access path, use the following steps:

Zoom into the file. Type Z next to any relation for the selected file on the Edit Database Relations panel and press Enter. Alternatively, you can use selection option 2 from the Edit Model Object List panel.
The Edit File Details panel displays with a list of any existing (default) access paths for the file.
Add the new access path. At the next available line on this panel (use the Roll Up key, if necessary), type the access path value type in the Typ column and the name of the access path in the Access Path column and press Enter.
Your options for the Typ column are UPD, RTV, RSQ, QRY, and SPN.

For more information on each access path type and when to use it, see the "Access Paths: An Introduction" chapter in this guide.

CA 2E displays the following information for the new access path:
- Source member name in the Source Mbr field
- Unique and non-unique key selection in the Key field
- Maintenance selection (immediate, delay, and rebuild) in the Index field
View the access path details. Type Z next to the new access path and press Enter.
The Edit Access Path Details panel displays.

At this point, you have defined an access path to the model.

For more information on making changes to the access paths, such as to the keys, or to add virtuals, see the instructions in the "Modifying Access Paths" chapter of this guide.

For additional instructions that are commonly used when adding RSQ, QRY, and SPN type access paths, refer to that material in the following sections.