DB2 SQL Training

COALESCE returns the first argument that is not null The arguments are evaluated in the order in which

I'm using a DB2 UDB Query Optimizer and it is using COLASCE function while optimizing a query in almost all the queries optimization it is

coalesce synonyms 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

coalesce db2 COALESCE CONNECTION_ID CONV CONVERT CURRENT_USER DATABASE IF IFNULL ISNULL LAST_INSERT_ID NULLIF SESSION_USER SYSTEM_USER USER VERSION · SQL Server Functions