Hello,

I have created a view in DB2 which runs fine on my version of DB2 which runs on a windows machine.

When i then try to run this same create view statement in iSeries (AS400) it comes back with the following error:

[SQL0101] SQL statement too long or complex.

The statement contains 4 sub selects and 8 joins. There seems to be a difference between the Windows versionand the iSeries...

Can anyone help?

It can be related to the statement heap size.. check this out..