Introduction to Access Paths › Changing Values › Controlling Auxiliary Names

Controlling Auxiliary Names

CA 2E generates default values for access path auxiliaries for Query (QRY) access paths and SQL tables or views with *IMMED maintenance capability.

For more information about:

• SQL generation, see Specifying Generation Mode later in this section.
• SQL naming and separate view and index creation, see the "SQL Implementation" appendix in the Administration Guide.

Change the name of auxiliaries using the following procedure:

1. Zoom into the file.

   At the Edit Database Relations panel, type Z next to the relation for the file and press Enter.

   The Edit File Details panel displays.

2. Zoom into the access path.

   Type Z next to the selected QRY (or SQL) access path and press Enter.

   The Edit Access Path Details panel displays with the details for the selected access path.

3. View the auxiliaries.

   Press F7 to view the access path auxiliaries.

   The Edit Access Path Auxiliaries panel displays.

4. Type the new source member names and press Enter.