Re: file access problem.....

["Peter Dow" <pcdow@xxxxxxxxx>]

Hi Doug,

I haven't tested this, but you might not get the first record added if
you're reusing deleted records and timing is such that the first record
added goes to the end of the file and the 2nd record added fills in an
earlier rrn that just got deleted.

Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax


----- Original Message -----
From: Doug Holmes <doug@netserv.ouac.on.ca>
To: <MIDRANGE-L@midrange.com>
Sent: Wednesday, August 02, 2000 11:43 AM
Subject: Re: file access problem.....


> Hi,
>
> You're right that you can add more than one record with the same key
because it's non-unique.
>
> But, using CHAIN to access your file, you will always get the first record
added because it's
> relative record number is lower - records in a keyed physical file are
"sorted" by the relative
> record number within each key value.  We've encountered this at our shop
and are having to find
> ways around it to get at the subsequent records (e.g. adding logicals with
another key field which
> makes it unique, CHAIN/SETLL's and READ's, etc.)
>
> Hope this helps.
> Doug
>
>
> From:           Curtisda@aol.com
> Date sent:      Wed, 02 Aug 2000 13:18:32 EDT
> Subject:        file access problem.....
> To:             <MIDRANGE-L@midrange.com>
> Send reply to:  MIDRANGE-L@midrange.com
>
> > 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
> > +---
>
>
> _________________________________________________________________
>
>   Doug Holmes
>   Programmer/Analyst
>   Ontario Universities' Application Centre
>   P.O. Box 1328, 650 Woodlawn Road West
>   Guelph ON, CANADA  N1H 7P4
>   TELEPHONE: (519)823-1940, x 224   FAX: (519)823-5232
>   www.ouac.on.ca
> _________________________________________________________________
> +---
> | 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
> +---


__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com
+---
| 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
+---