Re: Logical file order of records

["Bob P. Roche" <BRoche@xxxxxxxxxxxxxxxxx>]

The order they were entered in the file. Basically the record number.



From:
Neill Harper <neill.harper@xxxxxxxx>
To:
"'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
Date:
11/05/2009 02:10 PM
Subject:
Logical file order of records
Sent by:
<midrange-l-bounces@xxxxxxxxxxxx>



If I have a unkeyed PF FILEA as follows:

 

Field1, Field2, Field3, Field4

 

I then have an LF LFA, with a non unique key of Field1,Field2,Field3 

 

When there is more and one record with identical Field1,Field2 and Field3
columns, what controls the order of the remaining records. 

 

Further to this, if I had 2 copies of FILEA in different libraries with
EXACTLY the same data in would you expect LFA in both libraries to show 
the
records in exactly the same order?