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 !