Having trouble with DB2/400 UDF returning a table.
Anyhow I tried running it using interactive SQL. I waited about 30seconds and got a "Query cannot be run" error due to timeout.
I used a service program to debug my rpgle program and the program seems to be working fine. all of the input parms come in correctly and the output parm is being built correctly. I'm returning '02000' as my SQL return code and turning *INLR = *ON.
I watched it run in debug mode and it just loops around and around and never returns a value. I would expect that it would only run once and return a value.
Any ideas? I could provide the source code if that would be helpful....



