Connect CDC SQData

The ISNULL (Is Null) function determines whether or not a value is null. If the value is null, a true (1) is returned. Otherwise, a false (0) is returned.

Category

Boolean

Syntax

ISNULL(value)

 

Parameter Descriptions

value  -  This parameter specifies the value to be tested to determine whether or not it contains a null value. The value to be tested can be a field from a source datastore, a variable or the result of another Function. 1 | 0 Indicates whether a TRUE (1) or FALSE (0) was returned from the ISNULL function.

Example

Determine whether or not an employee’s address (EMP_ADDR) contains a null value. If the address is null, map a space (' ') to target field EMP_ADDR. Otherwise, map the source field to the target field.

IF ISNULL (EMP_ADDR) = 1

{

   TGT_DS.EMP_ADDR =   ''

}

ELSE

{

   TGT_DS.EMP_ADDR =   EMP_ADDR

}