Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2002
    Posts
    4

    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

  2. #2
    Join Date
    Aug 2002
    Posts
    35
    I am sure that is not the full size. I t can easy more than 10,000. Let me know more details.
    vasu

  3. #3
    Join Date
    Jun 2002
    Location
    UK
    Posts
    525
    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).

  4. #4
    Join Date
    Aug 2002
    Posts
    35
    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.
    vasu

  5. #5
    Join Date
    Nov 2002
    Posts
    14
    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.

Posting Permissions

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