Re: file access problem.....

[Jim Langston <jlangston@xxxxxxxxxxxxxxxx>]

What I have actually seen is one record will always be the one called up when 
you have duplicate keys.

The reason I know this is because we have a file with non duplicate keys, and 
one of our sites always
puts in a record with duplicate keys when they are not supposed to.  What 
always happens in this case
is the system keeps bringing up the first record and the users can never get to 
the second record (the
program, which I did not design, never assumes there will be duplicate keys).

So I would say, no, it is not random which record you will get, it is in 
arrival sequence by key.

I can not guarantee this, but I am 90% positive this is the way it is.

Regards,

Jim Langston

Date: Wed, 02 Aug 2000 13:18:32 EDT
From: Curtisda@aol.com
Subject: file access problem.....

Will someone please confirm or discredit my thinking about ....adding or 
accessing a file with non-unique key

If I add two records with the same key..... because the key is not specified, 
it will allow this..

When I go to access that key with a chain... there is not guarentee that I will 
get the first record added.. it is random
which record I will get.. because of the way the AS/400 stores data.....

Will someone weigh in on this.....



+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---