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 and Description
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
}