Pete,
What you are experiencing is what I always see when I open a table in query; that is, records in arrival sequence sans any sort keys.
You can verify this by adding a record to any keyed table where the key would not normally be at the end of the table and, then, bring the file into query and go to the end of the list. Your new record will be the last record.
That's just the way query works.
Jerry C. Adams
IBM System i Programmer/Analyst
B&W Wholesale
office: 615-995-7024
email: jerry@xxxxxxxxxxxxxxx
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Pete Helgren
Sent: Thursday, August 21, 2008 3:43 PM
To: Midrange Systems Technical Discussion
Subject: Sorting records in Physical and Logical files
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
--
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.
midrange.com
