experiences with stored procedures, triggers, and XML on DB2 v8

experiences with stored procedures, triggers, and XML on DB2 v8 coalesce db2 Converts a string or ROWID data type into a value of data type CLOB COALESCE For nullable columns, returns a value instead of a null ( coalesce synonyms The DB2 COALESCE function takes a comma separated list of arguments and returns the value of the first non-NULL expression found

coalesce synonyms 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 db2 COALESCE returns the first argument that is not null The arguments are evaluated in the order in which Another work-around would be to use PROC SQL Pass-Through with the COALESCE function and create the SAS table as such: