× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: Re: file access problem.....
  • From: "Peter Dow" <pcdow@xxxxxxxxx>
  • Date: Wed, 2 Aug 2000 13:05:01 -0700

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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.