Re: SQL: No order by in a subselect

One way is to put the SELECT into a QMQRY, then STRQMQRY
OUTPUT(*OUTFILE)
> This is a multipart message in MIME format.
> --
> [ Picked text/plain from multipart/alternative ]
> Obviously by the 'FETCH FIRST 20 ROWS ONLY' I am running V5R1.  Is there a
> method to do what I am trying to do below - list the top 20 into a file?
> Using the Order by clause in a subselect is not allowed.
>
>
>       Insert into dirbig
>       (SELECT IFSLDIR,IFSLOBJ,IFSLSIZ,CURRENT DATE
>        FROM IFSLIST
>        ORDER BY IFSLSIZ DESC
>        FETCH FIRST 20 ROWS ONLY)
>
>
> Now I am thinking that I will be stuck with a cursor loop.
>
> I guess in the past the order by was only a minor frustration.  But now
> with this fetch first it's getting to be more of a PITA.
>
> Rob Berendt
> --
> "They that can give up essential liberty to obtain a little temporary
> safety deserve neither liberty nor safety."
> Benjamin Franklin
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>