IFNULL scalar function

The IFNULL function returns the first non-null expression in a list of two expressions.

Read syntax diagramSkip visual syntax diagram IFNULL ( expression1 , expression2 )

The schema is SYSIBM.

The IFNULL function is identical to the COALESCE scalar function, except that IFNULL is limited to two arguments.