Hi all,
I have a union with six subqueries.This is the error I receive when I execute the query
UDA-SQL-0107 A general exception has occurred during the operation "prepare".
[IBM][CLI Driver][DB2/6000] SQL0101N The statement is too long or too complex. SQLSTATE=54001.
Initially it was a much bigger query.i tried to bring it down to 6.I still get this statement complex error.The tables i use are not too big.The query has about
35 fields.Is that what is making it complex?
How do i resolve this issue?
This is not really a Cognos issue. The problem is with DB2/6000 and the SQL complexity involved. A possible approach is to simplify step by step untill the query executes and then take it's definition to a DBA for advice.