Data Modeling › CA 2E Access Paths › Adding New Access Paths for HORSE

Adding New Access Paths for HORSE

In this step you will add some new access paths as well as update the default Retrieval (RTV) access path. This will demonstrate some of the more sophisticated capabilities of access paths.

For example, you can define an access path to select only certain relations from the file or to include selection criteria based on conditions specified for certain fields. In this tutorial, you will specify new access paths that select only mares or only stallions from the HORSE file. Call these new RTV access paths Mares and Stallions.

Type the names of the new RTV access paths, Mares and Stallions.

Press Enter.