MVSFORUMS.com

[Joy]

DB2 UDB is not supporting nested function calls beyond the Second Level for User Defined Functions(UDF's)i.e its fine if one UDF calls another UDF however if the second UDF calls another UDF then DB2 is complaining saying that the statement is too complex to be handled.However when i am copying the body of the 3rd UDF in place of the function calls in the second UDF its working fine.Can someone tell be how to resolve this problem.One suggestion that i have received is to increase the Statement Heap Size.How can I do this?

[kolusu]

Joy ,

Check this link which explains in detail about increasing the heap size.

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAPH10/3.3.3.2.3?SHELF=&DT=20010209162045&CASE=

Hope this helps...

Cheers

kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu