VALUE scalar function The VALUE function returns the first argument that is not null. VALUE(expression ,expression) The schema is SYSIBM. VALUE is a synonym for COALESCE.