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 10‑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 10‑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.