> If I set NO_SUBQF=1 then select works correctly still in Linux IDS
9.40.UC6
> I don't find any documentation about this environment variable. How does
this variable work ?

I understand that this variable turns off a feature in the query optimizer.
With this feature turned on the optomizer tries to flatten certain
subqueries (turns them into a join).
Apparently this is not working in every case.
Here's a short description of the variable:

http://www-1.ibm.com/support/docview...id=swg21173572

Matthias