DB2 Version 9.7 for Linux, UNIX, and Windows

NVL scalar function


                       .---------------.      
                       V               |      
>>-NVL--(--expression----,--expression-+--)--------------------><

The schema is SYSIBM.

The NVL function returns the first argument that is not null.

NVL is a synonym for COALESCE.