Re: Sorting records in Physical and Logical files

[Simon Coulter <shc@xxxxxxxxxxxxxxxxx>]

On 22/08/2008, at 8:36 AM, Pete Helgren wrote:

> I thought DDS had broader implications than just in RPG programs.

It does. It affects COBOL and C programs too as long as they, like  
RPG, specify keyed processing.

Query products can choose to use the keyed access path just like  
HLLs. Whether a Query product uses arrival sequence or keyed sequence  
depends on how it estimates the result. You can provide hints or help  
to get a Query product to favour keyed over arrival for reading but  
you can't force it.

You can force the order of the query result but that is different  
from an HLL where you force the order of the input (and get an  
ordered result as a by-product)

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  / \
--------------------------------------------------------------------