All -
in writing some User Defined Functions, I am getting this error




SQL0101N The statement is too long or too complex.



What I am doing is not that complex. Basically, performing 5 0r 6
queries insude the UDF and setting them to a variable.
Then parsing those variables using while loops and if statement to find a
valid pay day within a pay month.

It compiles file and loads into the database as well.

When I invoke , I get this error message:

db2 " select nextdraftday(34,' 214158052') from sysibm.sysdummy1"
SQL0101N The statement is too long or too complex. SQLSTATE=54001


The stmtheap parm is set to 8192 more than enough !


Any assistance would be appreciated.

Obviously not.