Please enable JavaScript to view this site.

The NULL function sets a variable or target field to a null value. This is similar to the EMPTY function.

Category

Specialized

Syntax

NULL()

 

Parameter Descriptions

This function has no parameters.

Example

If the value of source field SRC_FLD1 is a negative number, set target field TGT_FLD1 to a null value. Otherwise, map the source field to the target field.

IF  SRC_FLD < '0'

{

   TGT_FLD1 = NULL()

}

ELSE

{

   TGT_FLD1 = SRC_FLD

}