var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Does anyone know if there is a limitation to the size or number of lines of a DB2 stored procedure? I am running DB2 UDB v7.1 on Linux and using the stored procedure builder.
I have a rather lengthy stored procedure that after I get to a certain point I get the following error when I try to save it:
If I try to compile it I get:
Create stored procedure returns -99999.
[IBM][CLI Driver] CLI0118E Invalid SQL syntax. SQLSTATE=37000
The best I can tell is that it is a size limitation. If I cut back on the number of lines it saves and compiles fine, so I know it isnt anything in the code. Is there a parameter or something that I can change to correct this problem?
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors