COALESCE scalar function - Db2 SQL

coalesce db2   Dan coalesce db2

Basically, the whole point of COALESCE is that it is a function that returns the first value that is not NULL You can pass in as many (

The DB2 COALESCE function returns the value of the first non-NULL expression The COALESCE function takes a comma separated list of arguments which are DB2 has two functions that can be used to substitute values for a null COALESCE The two functions are identical in their

isildur poker but unable to use in DB2 Hi DCUnited, Using the coalesce () function is the correct approach From your post, it looks like your strings are  COALESCE); END @ create trigger trpca_rd_upd AFTER DB2, DB2 Codes , SQL Codes, SQL Error Codes, -478