hello,

I have an ORACLE SQL statement like below;

TK.HESAPKODU||'.'||TK.DUZEYKODU1
||DECODE(TK.DUZEYKODU2,NULL,'','.'||TK.DUZEYKODU2)
||DECODE(TK.DUZEYKODU3,NULL,'','.'||TK.DUZEYKODU3)
||DECODE(TK.DUZEYKODU4,NULL,'','.'||TK.DUZEYKODU4)
||DECODE(TK.DUZEYKODU5,NULL,'','.'||TK.DUZEYKODU5)
||DECODE(TK.DUZEYKODU6,NULL,'','.'||TK.DUZEYKODU6) KODU

How can i change it to DB2 CASE???


thanks

If changed straighforward to CASE, it would be like this:
CASE WHEN TK.DUZEYKODU2 IS NULL THEN '' ELSE '.'||TK.DUZEYKODU2 END

But, in this case, COALESCE would be simpler.
Like this:

raysefo,
you will have much less problem if you use standard SQL in Oracle too. Decode is Oracle specifics, coalesce is SQL standard. See also this blog post:
http://mennan.kagitkalem.com/NVLCOALESCEDECODE.aspx
Hope it helps,
Grofaty