RE: Problems with Query on V4R5

[Pete Hall <pbhall@xxxxxxxxxx>]

At 13:42 06/15/2001, Joe Giusto wrote:
>I always thought that the default ordering was by RRN if no other order was
>specified.  Even when I have selected one key field, the secondary sort
>seems to always be RRN after that key.  That is if memory serves me
>correctly.  For example, doing a RUNQRY over a logical file has always shown
>me the records in RRN order which was not the keyed order of the logical.
>This used to bother me when I first started using RUNQRY because I figured
>that the machine should be smart enough to use the key of the logical that I
>was querying.  After all, that is why I asked it to query the logical
>instead of the physical.  Of course I quickly "got over it" and have assumed
>RRN order by default ever since.

That's often the case, but I believe the actual result order is undefined 
if it's not explicitly specified, so you'll get whatever order is naturally 
produced by the dataset retrieval scheme that the query optimizer comes up 
with.

Pete Hall
pbhall@execpc.com
http://www.execpc.com/~pbhall/

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---