Home > IT Answers > SQL Server > DB2 Recursive UDF
jen1981
5 pts.
 DB2 Recursive UDF
AS400 V5R2, DB2 SQL
I am looking to create a SQL table UDF on my AS400(v5r2) that will return a listing of suboridinates for a given manager. Is it possible to use recursion? Since we are on v5r2 recursive SQL is not an option

Software/Hardware used:
AS400 V5R2 DB2 SQL
ASKED: December 19, 2011  9:29 PM
UPDATED: February 28, 2012  2:46 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

…will return a listing of suboridinates…

Please define “a listing”. E.g., a string of comma-separated values?

What development tools do you have? Can you code a RPG stored proc to return a result set?

Tom

TomLiotta
 110,135 pts.