Re: Sorting records in Physical and Logical files

On 22/08/2008, at 7:26 AM, 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.

Only if you CHOOSE to use it. You do that in programming languages by specifying keyed access. You need to read the file in keyed sequence to get DB top provide the records in that order.

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

Files (including logical files) have an arrival sequence access path and 0 or more keyed sequence access paths. If you don't specify keyed processing you will get arrival sequence.

Note that arrival sequence is upset by REUSEDLT in that records are no longer returned in true arrival (i.e., the order in which they were written) sequence.

Regards,
Simon Coulter.
--------------------------------------------------------------------
FlyByNight Software OS/400, i5/OS Technical Specialists

http://www.flybynight.com.au/
Phone: +61 2 6657 8251 Mobile: +61 0411 091 400 /"\
Fax: +61 2 6657 8251 \ /
X
ASCII Ribbon campaign against HTML E-Mail / \
--------------------------------------------------------------------