Previous Topic: Displaying the Access Path Format EntriesNext Topic: Compiling the QRY Access Path


Specifying an Alternative Key

Specify Horse name and Race date as the alternate keys of the access path. You can assume that each horse runs in no more than one race per day; as a result, Race time is not required as a key.

Define the keys by changing entries in the Key no. column as shown; namely, blank the Key no. field for Course code, Race time, and Entry number, and type 1 for Horse name.

Press Enter. Press F3 twice to exit to the Edit File Details panel.