This keyword tells CONNX not to create a temp key, and to use the Cartesian product instead.  Without the use of the {notempkey} escape clause, CONNX creates a temporary key to perform the join.  With the {notempkey} escape clause, CONNX forms a brute force nested loop to perform the join.

 

Example:

SELECT * FROM customers a, customers b WHERE a.customername = b.customername and a.customeraddress = b.customeraddress  {notempkey}