Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005

    Unanswered: DB2 Create View Problem..


    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?

  2. #2
    Join Date
    Nov 2004


    It can be related to the statement heap size.. check this out..
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts