Re: Embedded SQL: ORDER BY

["Mike Naughton" <mnaughton@xxxxxxxxxxxx>]

Hi Phil,

I think the short answer is "no" -- in fact, you can't order by anything
that has not been included in the "select" statement first. When you think
about it, this makes sense -- SQL will select the appropriate rows first
(but only the columns you specifiy), and then order them -- how can it
order by something whose value it doesn't know?

I think the only way to do this is to include all the columns, and if you
don't need them elsewhere then just ignore them in the rest of your
program. . . .

RPG400-L@midrange.com writes:
>In sql/400, is there a way to sort based on a substring of a field like
>this:
>
>    select * from myfile order by substr(myfield,1,2)
>
>I've only been able to do it if I explicitly include the new field
>
>    select substr(myfield,1,2) from myfile order by substr(myfield,1,2)
>
>the bummer being that I have to also explicitly include all other columns
>that I need.
>
>Phil



Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA  01376
413-863-4357 x444
mnaughton@juddwire.com

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