1. Access Paths: An Introduction

This chapter contains an introduction to the types of access paths and a high level overview of the CA 2E concepts for building access paths.

2. Setting Default Options for Your Access Paths

This chapter contains conceptual material and instructions on setting CA 2E model values for allocating prefixes, file names and SQL libraries. It also includes details on generating database file values and instructions on changing compiler overrides.

3. Adding Access Paths

This chapter contains conceptual material and instructions for editing file details and adding the following six access paths: physical, update, retrieval, resequence, query, and span.

4. Modifying Access Paths

This chapter contains conceptual material and instructions on how to modify existing access paths, including the details, format entries, relations, and auxiliaries. It also contains information on modifying virtual field entries and select/omit criteria.

5. Deleting Access Paths

This chapter contains conceptual material and instructions on how to delete existing access paths.

6. Defining Arrays

This chapter contains conceptual material and instructions on how to add, edit, and delete an array.

7. Generating and Compiling

This chapter contains conceptual material and instructions on how to set up your generation options and how to generate and compile your access paths.

8. Documenting Access Paths

This chapter contains conceptual material and instructions on how to document the access paths created in CA 2E.

9. Tailoring For Performance

This chapter contains material that can help you tailor your access paths to obtain the best system performance.