Hi,

I simply got stuck here. When I try to compile the source, I get an Error that the Statement is too complex or too long. Now I've compiled the source against a DB2 on Windows and it worked perfectly fine. Against the Z/OS I get that error. Now I did a bit research and found out that I should raise the STMTHEAP, but how? On Windows it's nor problem, but i hardly think it will work the same on Z/OS.

DB2 Version is btw. 8.1.5 ...

The problem is that in DB2 for z/OS there are some limit, such as:

Maximum number of tables in a FROM clause: 225
Maximum number of subqueries in a statement: 14
Longest SQL statement: 32767 bytes
Maximum number of elements in a select list: 750
Maximum number of predicates in a WHERE or HAVING clause: 750
Maximum total length of columns of a query operation
requiring a sort key (SELECT DISTINCT, ORDER BY,
GROUP BY, UNION without the ALL keyword, and the
DISTINCT column function): 4000 bytes

I hope this may be useful.

Definitly it is, especially the part with the longest statement. I took a look, and one of my statements is 38925 bytes long...

And...I guess...there is no way raising that limit?

No, unfortunately.

Well.....hmpf.....thanks anyway