This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
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.