var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Stored Procedure Size
If the stored procedure in UDB V 7.2 goes beyond some length (1000 or more lines), UDB cannot able to compile that. Do you know how to solve this problem,
We are currently breaking it up into small parts and compiling it. Please let me know if you have got any other solution
I am sure that is not the full size. I t can easy more than 10,000. Let me know more details.
I've experienced a similar problem. From memory, I think that there was a 32k limit to the script size not just statements within the script.
Presumably, you can increase the amount of code in your SPs by removing comments and whitespace?
I don't know of any way to get round this (including using the SP builder).
Lets say stored procedure has 40 input or outputs. YOu can have
eqach input or output as 32K. So it is more than 32K*40 but each parameter is limited to 32k.
DB2 treats the CREATE PROCEDURE statement as an SQL statement. The size limit for an SQL statement on Unix (and NT) is 64K. It is only 32K on the 390. A workaround would be to Nest the stored procedures.