RE: In-line Ifs in i-Series SQL

["Paramasivam Murugesan , Gurgaon" <ParamasivamM@xxxxxxxxxxxxxxx>]

Charles
Precisely ....This is the one which i looked for;)

Thanks a ton. I will go thru the manual to dig more.

-Murugesh


-----Original Message-----
From: CWilt@xxxxxxxxxxxx [mailto:CWilt@xxxxxxxxxxxx]
Sent: Monday, April 19, 2004 6:38 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: RE: In-line Ifs in i-Series SQL


Assuming I'm understanding your question correctly, you want the CASE
expression.....


select field1,
   case field2
     when 0 then field3
     else field4
   end
from myfile
where 
   (case 
     when field5 = 'Something' then NULL
     else field6
    end) > 15
 and field7 = 5


Note: if you happen to be look for an "If column = NULL" then instead of
CASE you can use the IFNULL or COALESCE functions.

Here's a link to the manuals:
http://publib.boulder.ibm.com/iseries/v5r2/ic2924/info/db2/rbafzmstdatetimea
rith.htm#HDRCASEEXP


HTH,
Charles




> -----Original Message-----
> From: Paramasivam Murugesan , Gurgaon
> [mailto:ParamasivamM@xxxxxxxxxxxxxxx]
> Sent: Monday, April 19, 2004 2:24 AM
> To: RPG programming on the AS400 / iSeries
> Subject: In-line Ifs in i-Series SQL
> 
> 
> 
> Hi all,
>       Apologize for my earlier mail. Any Example, How are 
> 'In-line If's
> coded in SQL statements?.. I dont know whether this is 
> allowed in in SQL/400
> or not.
> 
> TIA,
> Murugesh
> _______________________________________________
> 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.
> 
_______________________________________________
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.