Re: Logical file order of records

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

Dennis

I assumed that the OP did not know about FIFO and all that. Not everyone 
notices that extra keyword when just making a key - we don't notice what 
is defaulted.

Now having said that, I wonder what happens with FIFO in a RESUEDLT 
situation - have never tried it. My guess is that RRN is used, so it 
could alter things over time. But maybe there's some internal value that 
works differently - not aware of it, and not ready to do a test right now!

Later = off to the home front!!
Vern

Dennis Lovelady wrote:
> > The database does include in that /complexity/, the ability to
> > specify the ordering of duplicate key values; e.g. LIFO, FIFO, FCFO,
> > in DDS.  Not all accesses to database data are via query, so
> > realize that non-SQL & non-query interfaces used to read-by-key can
> > actually effect a read-order to reflect whatever was specified as
> > the [build]duplicate-key-order rule(s).
> >     
>
> I didn't notice that the originator specified that DDS was involved, and
> responded with SQL on my mind.  Besides, if the files had had that
> specified, I don't think the question would have been asked.  Right?
>
> Dennis Lovelady
> http://www.linkedin.com/in/dennislovelady
> --
> "An intellectual is a man who takes more words than necessary to tell more
> than he knows."
>         -- Dwight D. Eisenhower
>
>