Help - Update using coalesce - IBM: DB2 - Tek-Tips

coalesce db2   Dan coalesce bigquery

Returns a CLOB representation of string COALESCE Returns the first argument that is not NULL

The COALESCE function is used in DB2 zOS to handle NULL values in SQL queries It returns the first non-NULL value in a list of expressions  The COALESCE function is used in DB2 zOS to handle NULL values in SQL queries It returns the first non-NULL value in a list of expressions

ple stores Description COALESCE accepts a comma separated list of parameters and returns the first value that is not null in that list or null if all the arguments are DB2 = AA ' : AL , FI : IE