aspose file tools*
The moose likes JDBC and the fly likes decode in db2 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "decode in db2" Watch "decode in db2" New topic

decode in db2

Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
I have a requirement like
if payment_type = 's' then compensation is weekly_rate * 4
but if weekly_rate is 0 or null then compensation is 0
if payment_type = 'p' return the value in gross_amount column.

Below is the decode function I have used. Would like to know how to do the same using db2 functions.

Decode(payment_type, �s�, (decode(nvl(weekly_rate,0.00),0.00,0.00, weekly_rate*4)) ,�p�,gross_amount)
I agree. Here's the link:
subject: decode in db2