TIBCO Data Virtualization® Adapter Online Help > TDV DB2 Adapter > DB2 Function Support > DB2 Conditional Function Support
 
DB2 Conditional Function Support
TDV supports the conditional functions listed in the table below for DB2.
DB2 Conditional Function
Notes
COALESCE
 
DECODE
Mapped to CASE.
NULLIF
NULL not supported; BLOB, CLOB, LONGVARCHAR_FOR_BIT_DATA, LONG_VARCHAR arguments not allowed. For string comparisons, ignores trailing spaces.