jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases and the fly likes decode in db2 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: http://aspose.com/file-tools
subject: decode in db2
jQuery in Action, 3rd edition