RE: SQL "ORDER BY" and CASE

["ile rpg" <ile_rpg_guy@xxxxxxxxxxx>]

I don't seem to be able to sort on two keys in the same CASE group?  I'm 
experimenting with another CASE statement...

-irg


> From: "Hauser, Birgitta" <Birgitta.Hauser@xxxxxxxxxxx>
> Reply-To: RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
> To: "'rpg400-l@xxxxxxxxxxxx'" <rpg400-l@xxxxxxxxxxxx>
> Subject: RE: SQL "ORDER BY" and CASE
> Date: Mon, 23 Feb 2004 10:06:13 +0100
>
> Hello,
>
> Order by Case is supported from release V5R2M0 on.
> The colomns in the same case statement must have the same field type, like
> character, decimal or time.
> Different field types must be put into different case statements:
>
> For example:
> C/EXEC SQL
> C+ Declare  $SQLC1 Cursor For
> C+ Select   Name1F, Strasse, Ort
> C+ from     HsJako2003/Adresse
> C+ order by Case When :$Sort = 'NAME' then Name1F
> C+               When :$Sort = 'STR'  then Strasse
> C+               When :$Sort = 'ORT'  then Ort
> C+          Else NULL
> C+          End,
> C+          Case When :$Sort = 'TIME' then CrtTime
> C+          Else NULL
> C+          End
> C+ For Read Only Optimize for 3 rows
>
> Birgitta
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.

_________________________________________________________________
Dream of owning a home? Find out how in the First-time Home Buying Guide. 
http://special.msn.com/home/firsthome.armx