Introduction to Access Paths › Changing Values › Changing the Generation Mode at the Access Path Level

Changing the Generation Mode at the Access Path Level

To change the generation mode for a specific access path at the access path level:

1. Zoom into the file. At the Edit Database Relations panel, type Z next to the relations for the file and press Enter.

   The Edit File Details panel displays.

2. Zoom into the access path. Type Z next to the access path whose generation mode you want to change and press Enter.

   The Edit Access Path Details panel displays.

3. Change the generation mode. Type the character that represents the new generation model value.

   Options are:

   • D for DDS
   • S for SQL
   • M for MDLVAL

   Note: If an access path specifies M for MDLVAL when it is generated, it will use the current value for the YDBFGEN model value. If you want to override this value, enter D or S. The default is M.

4. Press Enter.