RE: Uncertain on CHAIN vs. SETLL/READE

Hi David

A very quick google turns up the following from the DDS Reference: Physical
and Logical Files:

"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."

The other two abbreviations:

FCFO (First-Changed First-Out) keyword for physical and logical files
LIFO (Last-In First-Out) keyword for physical and logical files

This is what a cursory read of Simons email and a bit of thought about it
suggested to me but I confirmed it in the manual anyway. Hope it helps you.

Give your apparent time limitations, can I ask - are you OK for socks and
undies as well ? :)

Regards
Evan Harris

Please take this in the good humour it was intended ! :)



-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of David FOXWELL
Sent: Tuesday, 13 January 2009 10:15 p.m.
To: RPG programming on the IBM i / System i
Subject: RE: Uncertain on CHAIN vs. SETLL/READE

Happy new year Simon!

Would you care to elaborate on your reply which seems to put some doubt on
the other responses to James' post?

I don't have time to go reading up on FIFO, LIFO, FCFO in the DDS and I'm
sure that a lot of us would benefit from your reply.

Thanks.



-----Message d'origine-----
De : rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] De
la part de Simon Coulter
Envoyé : samedi 10 janvier 2009 06:31
À : RPG programming on the IBM i / System i
Objet : Re: Uncertain on CHAIN vs. SETLL/READE


On 10/01/2009, at 12:10 PM, James Lampert wrote:

I know that a SETLL with only the leading keyfield, followed by a
READE with that same keyfield, is guaranteed to come back with the
first record with that leading key.

But is that also true of a CHAIN with just the leading keyfield?

The action of both keyed reads will depend on the use of FIFO, LIFO, FCFO in
the DDS.

Regards,
Simon Coulter.