Re: Keyed PF

["Steve Landess" <steve_landess@xxxxxxxxxxx>]

> Paul wrote:
> Here's a simple question that I can't remember the answer to.  If I have a
> PF keyed, non-unique, in what order will duplicate keyed records be
> accessed?  I'm guessing arrival sequence but could be wrong.  Thanks.
>

Paul -

Until you asked this question, I always thought it was arrival sequence, in
the case of duplicate key values.

However, if you look here in the iSeries Info Center:

http://publib.boulder.ibm.com/iseries/v5r1/ic2924/info/rzakb/rzakbmst50.htm#
HDRTDFIFO

it says:
FIFO (First-In First-Out) keyword for physical and logical files
Use this file-level keyword to specify that if records with duplicate key
values are retrieved from the same physical or logical file member, they are
to be retrieved in a first-in first-out (FIFO) order.

This keyword has no parameters.

FIFO is not allowed with an FCFO, 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.

Hope this helps,

Steve Landess
Austin, Texas
(512) 423-0935