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

    Unanswered: DB2 Create View Problem..

    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?

  2. #2
    Join Date
    Nov 2004
    Posts
    374

    sql101

    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
    http://users.skynet.be/przytula/dbss.html

Posting Permissions

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