Modifying Access Paths › Understanding Access Path Auxiliaries › Editing Access Path Auxiliaries

Editing Access Path Auxiliaries

Note: Auxiliaries are not applicable for DDL type file as Views are not created for DDL type file and only Index with the same name as the source member name is created. F7=Auxiliaries is not applicable for the DDL implementation.

Use the Edit Access Path Auxiliaries panel to display and change the auxiliary details for a QRY (or SQL) access path including changing source member names.

1. Zoom into the file.

   At the Edit Database Relations panel, type Z next to any relation for the selected file and press Enter. Alternatively, you can, select option 2 from the Edit Model Object List panel.

   The Edit File Details panel displays.

2. Zoom into the access path.

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

   The Edit Access Path Details panel displays.

3. View the auxiliaries.

   Press F7.

   The Edit Access Path Auxiliaries panel displays.

Note: In order to get the F7 option for auxiliaries, you must zoom into the access path by typing Z next to the access path.

1. Edit the auxiliaries.

   Change any of the following details as appropriate:

   • Source Member Name
   • Source Member Text
   • Index Name for SQL only. Enter *NONE to suppress generation of the SQL index.
2. Generate the access path.

   For the new specifications to take effect, you need to regenerate the access path.

For more information about how to generate the access path, see the instructions in the chapter "Generating and Compiling."