Please enable JavaScript to view this site.

The IFNULL command is used for checking whether a source Datastore field is null or not and if it is, initialize its value or raise an Exception.

 

Syntax

IFNULL <source_field> SETSPACE | SETZERO | SETEXP

 

Keyword and Parameter Descriptions

<source_field>  Specifies the name of a source field/column.

SETSPACE  Keyword that specifies the Null source field/column will be replaced with Spaces.

SETZERO Keyword that specifies the Null source field/column will be replaced with Zero.

SETEXP Keyword that specifies an Exception will be raised if the value of the source field/column is NULL. While this will cause the Apply Engine to terminate, it indicates that it has been previously determined that the condition cannot be resolved simply by changing the data to a predetermined the value.

Example

If a NULL value is found in source_field1,  set the value of the field to Spaces before performing any source to target mapping.

IFNULL CDCIN.DEPT_NAME SETSPACE;