COALESCE in DB2 returning empty - sql

The DB2 Design Advisor in IBM DB2 Universal Database^TM Version show how “time-coalesce” operation can be expressed directly in

COALESCE, + COALESCE, + Support for DB2 Universal Database for i, also known as DB2400, version

coalesce synonyms The COALESCE function returns the first non-null expression in a list of expressions The schema is SYSIBM The arguments are evaluated in the order in

coalesce معنى DB2 is to check for NULL values and it can be used in place of NULL indicator or COALESCE function The VALUE function replaces the column