RE: Problems with Query on V4R5

["Joe Giusto II \(E-mail\)" <juicenetdps@xxxxxxxxxxxxxx>]

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.



Joe Giusto II
Programmer/Analyst
Ritz Camera
Beltsville, MD
301-419-3209 x347
410-813-2812 x347

 -----Original Message-----
From:   owner-midrange-l@midrange.com [mailto:owner-midrange-l@midrange.com]
On Behalf Of Rolf Mittag
Sent:   Thursday, June 14, 2001 3:22 PM
To:     MIDRANGE-L@midrange.com
Subject:        Re: Problems with Query on V4R5

I think it has to do with how SQL works, as
the eSeries iSeries now is an SQL-machine.
SQL does not retrieve records in an ordered
sequence unless it's explicitly specified with
"order by".

---------------------------
Dipl.Inf.(FH) Rolf P Mittag
IBM Partner in Development
Leipziger Str. 50
D-69214 Eppelheim
Fon: +49 (6221) 76 78 60
Fax: +49 (6221) 76 80 26
eMl: rm@r-m-e-d-v.de



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