Use this file-level keyword to specify that if records with duplicate key values are retrieved from the same physical or logical file member, the record with the key value that was changed first is the first record retrieved. This is a first-changed first-out (FCFO) order.
This keyword has no parameters.
FCFO is not allowed with an FIFO, LIFO, UNIQUE, or REFACCPTH keyword.
If you do not specify FCFO, LIFO, FIFO, or UNIQUE, records with duplicate key values are retrieved in first-in first-out (FIFO), last-in first-out (LIFO), or first-changed first-out (FCFO) order, but the order in which they are retrieved is not guaranteed.
With the FCFO keyword, the records are ordered by when the record key value is changed. With the FIFO and LIFO keywords, the records are ordered by the relative record number.
At least one key field must be specified in the file containing the FCFO keyword. The FCFO keyword is not valid when you specify FILETYPE(*SRC) on the Create Physical File (CRTPF) or Create Logical File (CRTLF) command.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.