Mapping multi-row Boolean operators: MultiRowBoolFuncMapper element

The MultiRowBoolFuncMapper element is used for customizing the mappings of the multi-row Boolean operators listed in Table 11-16. The table also shows the default template for each operator.

The = ANY and <> ANY operators are implemented using the IN and NOT IN operators. The = ALL operators are implemented using the = ANY operators.

Table 11-16

Default templates for mapping multi-row Boolean operators

Multi-row Boolean operator	Operand data types	Default template	Remarks
EXISTS	<TABLE>	EXISTS $P0
IN	<INTEGER>, <TABLE> <DECIMAL>, <TABLE> <DOUBLE>, <TABLE> <VARCHAR>, <TABLE> <TIMESTAMP>, <TABLE>	$P0 IN $P1
NOT IN		$P0 NOT IN $P1	Use NOT_IN as FunctionName for NOT IN.
< ANY		$P0 < ANY $P1	Use LT_ANY as FunctionName for < ANY.
> ANY		$P0 > ANY $P1	Use GT_ANY as FunctionName for > ANY.
<= ANY		$P0 <= ANY $P1	Use LE_ANY as FunctionName for <= ANY.
>= ANY		$P0 >= ANY $P1	Use GE_ANY as FunctionName for >= ANY.

Copyright Actuate Corporation 2012