Mapping NULL functions: NullFuncMapper element

The NullFuncMapper element is used for customizing the mappings of the NULL functions listed in Table 11-13. The table also shows the default template for each function.

Table 11-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:

<NullFuncMapper>

  <FunctionMappings>

    <FunctionMapping FunctionName="CAST_NULL_AS_INTEGER"

      Disabled="true" />

    <FunctionMapping FunctionName="CAST_NULL_AS_DECIMAL"

      Disabled="true" />

    <FunctionMapping FunctionName="CAST_NULL_AS_DOUBLE"

      Disabled="true" />

    <FunctionMapping FunctionName="CAST_NULL_AS_VARCHAR"

      Disabled="true" />

    <FunctionMapping FunctionName="CAST_NULL_AS_TIMESTAMP"

      Disabled="true" />

  </FunctionMappings>

</NullFuncMapper>

Copyright Actuate Corporation 2012