I thought I understood this but apparently I don't.
I have a physical and logical file with the following specs:
                           UNIQUE                    
R FASA809                   TEXT('List Workfile')     
-------------------------------------------------------
record layout here: 
 SLWID          6S 0       COLHDG('Absence ID')      
 SLW#           6S 0       COLHDG('Seq. Number')     
 SLWSN          9S 0       COLHDG('Sub SSN')    
K SLWID
K SLW# 
The logical file looks like:
                           UNIQUE
R FASA809                   PFILE(PASA809)
K SLWID
K SLWSN
The physical file has a randomly generated number in field SLW# and 
since the keys are SLWID and then SLW# in that order. I would expect the 
file to be ordered that way when I open it up in Query or a simple 
select with no ordering in SQL.  However, the file is always ordered in 
arrival sequence.  If I read through this file, I see the records in the 
order in which they were written in the file.  I *expected* them to be 
ordered by the key sequence.
What did I miss or misunderstand?
Thanks
Pete
As an Amazon Associate we earn from qualifying purchases.
	
 
This mailing list archive is Copyright 1997-2025 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.