IP modes

Block Join mode is applicable only in the row-based mode. In SQL pass-through mode, block join mode is not applicable, as the IP executes the query.

Pushdown Joins should not be implemented in the IP if it has marked support for Block Joins. Similarly, you should not implement Block Joins in the IP if you have implemented Pushdown Joins.