Re: Sorting records in Physical and Logical files

There is a REORGANIZE command that can be run to put records in key
sequence. Otherwise, it is arrival sequence.

The reorg cmd is RGZPFM.
It always removes deleted records.
Option to reorder records by the PF key (*FILE) or
by the key of a logical.
The *RPLDLTRCD actually says it will move recs from end of
file to replace deleted records (why?).
Reorganize Physical File Mbr (RGZPFM)
Data base file . . . . . . . . . FILE _______
Library . . . . . . . . . . . *LIBL__
Member . . . . . . . . . . . . . MBR *FIRST__
Key file: KEYFILE
Logical file . . . . . . . . . *NONE (*FILE, *RPLDLTRCD, or logical name)
Library . . . . . . . . . .
Member . . . . . . . . . . . .
Rebuild access paths . . . . . . RBDACCPTH *YES
Allow cancel . . . . . . . . . . ALWCANCEL *NO

Jim Franz

----- Original Message ----- From: "Booth Martin" <booth@xxxxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Thursday, August 21, 2008 5:58 PM
Subject: Re: Sorting records in Physical and Logical files

There is a REORGANIZE command that can be run to put records in key
sequence. Otherwise, it is arrival sequence.

Pete Helgren wrote:

In the DDS? I though the point of a logical file was to build an index
that was an alternate to the default sorting sequence of the Physical
file (among other things). Yes, I could issue an ORDER BY using SQL or
OPNQRYF by I though the file had a "natural" sorting order that was set
by the DDS.

So, there is no way to define a physical file using DDS to sort records
in anything other than arrival sequence?

Pete

Alan Shore wrote:

What you are seeing is in fact correct. You have to ORDER BY for the order
you want



Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxxxxx
P:(631) 244-2000 ext. 5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill

midrange-l-bounces@xxxxxxxxxxxx wrote on 08/21/2008 04:43:26 PM:

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.

--
---------------------------------
Booth Martin
http://www.Martinvt.com
---------------------------------

--
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.