Re: Logical file order of records

The trick is that this can be modified if you have reuse deleted records
turned on. In that case, the result would be random.

As far as the order in another library would depend on how it got copied. A
save and restore should be identical.

On Thu, Nov 5, 2009 at 1:13 PM, Bob P. Roche <BRoche@xxxxxxxxxxxxxxxxx>wrote:

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?









--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.




--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.