COALESCE in DB2 returning empty - sql

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

COALESCE Functions Among the built

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 bigquery Another work-around would be to use PROC SQL Pass-Through with the COALESCE function and create the SAS table as such: