Previous Topic: Identifying Access Path Format KeysNext Topic: Editing Access Path Format Entries

Modifying Access Paths › Modifying Access Path Format Entries › Changing the Key Sequence

Changing the Key Sequence

Do the following to change the key sequence

  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 use selection option 2 from the Edit Model Object List panel.

    The Edit File Details panel displays.

  2. Zoom into the access path.

    Type Z next to the selected access path and press Enter.

    The Edit Access Path Details panel displays.

  3. Zoom into the format.

    Type Z next to the selected format and press Enter.

    The Edit Access Path Format Entries panel displays:

    Changing the Key Sequence

  4. Change the key sequence.

    Change the key order as appropriate by changing the numbers in the Key no. column.

    Numbers represent the order of the fields that make up a composite key. Ensure that the key sequence numbers are unique. Low key order indicates the sequence of the major keys.

  5. Generate the access path.

    For the new specification to take effect, you must regenerate the access path.

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