The NullFuncMapper element is used for customizing the mappings of the NULL functions listed in Table 10‑13. The table also shows the default template for each function.
Table 10‑13 Default templates for mapping NULL functions
NULL function
Operand data types
FunctionName
Default template
IS NULL
<INTEGER>
<DECIMAL>
<DOUBLE>
<VARCHAR>
<TIMESTAMP>
Use IS_NULL as FunctionName for IS NULL.
$P0 IS NULL
CAST (NULL AS INTEGER)
Use CAST_NULL_AS_INTEGER as FunctionName.
Generated by the Integration service
CAST (NULL AS DECIMAL)
Use CAST_NULL_AS_DECIMAL as FunctionName.
CAST (NULL AS DOUBLE)
Use CAST_NULL_AS_DOUBLE as FunctionName.
CAST (NULL AS VARCHAR)
Use CAST_NULL_AS_VARCHAR as FunctionName.
CAST (NULL AS TIMESTAMP)
Use CAST_NULL_AS_TIMESTAMP as FunctionName.
Example: Disabling the CAST (NULL AS . . .) functions
Your database does not support the NULL literal, so the CAST (NULL AS . . .) functions must be disabled: