that's great! i tried the second option as my proc is too big... now it says applheapsz is not enough... can anyone know what are all the parameters are there & what is the default sizes for these parameters for various DB2 UDB products...
i'm using DB2 UDB v8.1.3/Windows 2000
as i told in my previous mail, one procedure get compiled by increasing the stmtheap, but other procedures not getting compiled saying 'The statement is too long or too complex'.. i increased the stmtheap & applheapsz to their max size '60000'... no use... the procedure has only 800 lines.. can anyone help me out... using DB2 v8.1.3 / windows 2000
If Im not mistaken the new release of DB2 v8.2(still in beta) - named Stinger - the stored procedure size has increased to 2MB. Check the IBM website - the search keyword "Stinger" -.
Maybe thats the only way to solve your stored procedure problem, chopping up your complex stored procedure into a group of smaller one. Try to incorporate UDF or another stored procedure into your stored procedure.