RE: Embedded SQL: ORDER BY

Thanks.

PHil

> -----Original Message-----
> From: owner-rpg400-l@midrange.com [mailto:owner-rpg400-l@midrange.com]On
> Behalf Of Mike Naughton
> Sent: Friday, June 29, 2001 10:06 AM
> To: RPG400-L@midrange.com
> Cc: rpg400-l@midrange.com
> Subject: Re: Embedded SQL: ORDER BY
>
>
> 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
> +---
>


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.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
+---