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
dBforums
>
Store procedure: The statement is too long or too complex
09-17-07, 08:09
Linear Mode
