All -
in writing some UDFs 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.sysdummy 1"
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.
in writing some UDFs 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.sysdummy 1"
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.