Handling null values in outer joins - DB2 Version -

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

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

coalesce bigquery 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 synonyms COALESCE CONNECTION_ID CONV CONVERT CURRENT_USER DATABASE IF IFNULL ISNULL LAST_INSERT_ID NULLIF SESSION_USER SYSTEM_USER USER VERSION · SQL Server Functions