Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    1,605

    Unanswered: Store procedure: The statement is too long or too complex

    Hi,
    creating a store procedure on DB2 v8 FP9 on Windows XP it creates without errors.

    But creating the same store procedure on DB2 v8 FP11 on Linux and DB2 v9 FP2 on Linux returns the following error:

    Code:
    DB21034E  The command was processed as an SQL statement because it was not a
    valid Command Line Processor command.  During SQL processing it returned:
    SQL0101N  The statement is too long or too complex.  LINE NUMBER=152.
    SQLSTATE=54001
    Any idea why DB2 for Linux reports error? Was some limitation introduced in fixpack?

    Parameters on v8 (both Windows and Linux) are default:
    Package cache size (4KB) (PCKCACHESZ) = (MAXAPPLS*8)
    SQL statement heap (4KB) (STMTHEAP) = 2048

    Parameters on v9 Linux are default:
    Package cache size (4KB) (PCKCACHESZ) = AUTOMATIC
    SQL statement heap (4KB) (STMTHEAP) = 2048

    Thanks,
    Grofaty
    Last edited by grofaty; 09-17-07 at 09:29.

  2. #2
    Join Date
    Jan 2003
    Posts
    1,605
    -------------------------------
    Last edited by grofaty; 09-17-07 at 10:19.

Posting Permissions

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