I am getting following error while I try to use a complex query to export the resultset.
SQL3022N An SQL error "437" occurred while processing the SELECT string in
the Action String parameter.
SQL0437W Performance of this complex query may be sub-optimal. Reason code:
SQL0437W is just a warning message for the select query and does return desired resultset. But because of that warning message my export command is failing with reason code 437 and error code SQL3022N .
This is ver 8.1 fixpack 5 on AIX 5.3 with 4 logical nodes.
I checked the forums and only error I got was for ver 6 that was fixed with service packs.
Has anyone faced such problem and how to resolve it?