I have a query like this.

select CHAR(DATE(CASE ae.EXEMPTIONGRANTEDDATE WHEN '' THEN ae.EXEMPTIONDENIEDDATE ELSE ae.EXEMPTIONGRANTEDDATE END), USA) from testdate


Here, WHEN '' - This null value is not accepted by date format in DB2. How to handle this here. i.e if ae.EXEMPTIONGRANTEDDATE is null I have to take the value ae.EXEMPTIONDENIEDDATE in CASE.

Plz reply as soon as possible.

COALESCE(ae.EXEMPTIONGRANTEDDATE, ae.EXEMPTIONDENIEDDATE)

returns the first non-null value in the series.

VALUE is a synonym for COALESCE.