Modifying Access Paths › Modifying Access Path Details › Specifying Unique/Duplicate Key Retrieval Sequence

Specifying Unique/Duplicate Key Retrieval Sequence

CA 2E lets you determine if the key values of the access path are unique or duplicate and, if they are duplicate, what the sequence would be.

1. Zoom into the file.

   From the Edit Database Relations panel, type Z next to the selected file and press Enter. 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. Specify the key sequence.

   Change the key sequence by entering the selected option in the Duplicate Sequence field and press Enter.

   The possible options are:

   • U for unique (this requires Immediate maintenance).
   • F for first in, first out (FIFO).
   • L for last in, first out (LIFO).
   • C for first changed, first out (FCFO).
   • Blank means an unspecified sequence is used.

For more information about the unique/duplicate key sequence, see IBM i DDS Reference Manual and IBM i Database Guide.