Re: file access problem.....

["Doug Holmes" <doug@xxxxxxxxxxxxxxxxxx>]

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
+---