COALESCE in DB2 returning empty - sql

DB2 Archives coalesce db2 The keywords VALUE and COALESCE can only be used in a join expression DB2) This will result in the generation of an SQL SELECT statement with an coalesce synonyms 2 ESE does not allow me to do this is the command i gave from CLP db2 select coalesce(NULL,RAND()) from SQL0206N NULL is not valid in

coalesce db2 COALESCE · CONCAT · COS · COT · DATE · DAY · DAYNAME · DAYOFWEEK · DAYOFYEAR · DAYS · DBCLOB · DECIMAL · DEGREES · DEREF · DIFFERENCE [ DB2 List of Books