RE: Uncertain on CHAIN vs. SETLL/READE -- RPG400-L

Thanks, Evan,

A reply from NZ! Well, that's basically Australia, I suppose.
I was half expecting Simon to not reply as I was admitting to refusing to search the archives. Worse still, I wished him a happy new year.

I'm sure however, that I'm not the only one who did not realise the implications of the keyword and I certainly will not forget it. Now where have I used a CHAIN on a file that has a non unique key?

As for underwear, funny you should ask. Midwinter and -10°C. How does that grab you?

-----Message d'origine-----
De : rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] De la part de Evan Harris
Envoyé : mardi 13 janvier 2009 12:05
À : 'RPG programming on the IBM i / System i'
Objet : 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.

--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l.