DB2 has two functions that can be used to substitute values for a null value, as will often be returned when outer joins are used.

The functions are:

VALUE(expression,expression,...)
COALESCE(expression,expression,...)

The two functions are identical in their operation. Each returns the first argument in the list that is not null.