Having trouble with DB2/400 UDF returning a table.
Home > IT Answers > Development > Having trouble with DB2/400 UDF returning a t...
Dwk001
5 pts.
0
Q:
Having trouble with DB2/400 UDF returning a table.
SQL, RPGLE, DB2/400, UDF, Table Functions
I've written a test RPGLE program (not a service program) to return a table that for testing puposes I'm returning 1 row and 1 hard coded return column that is defined as varchar. I'm building the return value by concatonating the input parameters.

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....
ASKED: Mar 4 2008  0:25 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Dwk001
5 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Last Answered: Mar 4 2008  0:25 AM GMT by Dwk001   5 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

BigKat   2540 pts.  |   Mar 7 2008  5:22PM GMT

Here is a link that might help

Build a New Interface to Legacy Applications with SQL UDTFs

 

TomLiotta   7490 pts.  |   Oct 30 2009  1:59AM GMT

Ideas? Without even seeing the basics of the structure of the code? Maybe it’s running Cycle code. Maybe it’s failing to increment/decrement a limit variable. Maybe it has a condition not being set for a DOW-loop. Maybe…?

Any chance we could see some useful code? How about the CREATE FUNCTION statement?

Can we at least know the OS version/release? How is it being referenced?

Tom

 
0