Thanks everyone.
From this I would gues it is something to do with the number of joins I am using.
Just out of interest - this only happens when I attempt to create a view. If I run the select statement without the CREATE VIEW etc a the beginning it runs fine, but as soon as you attempt to...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.