Discussion Locked
Recursive SQL for DB2 v6.x
0 helpful
0 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Any one have an example of how to do a recursive query in DB2 v6.x? The only syntax I've seen is for DB2 UDB 7.x.
I've seen some statements with left outer joins, but that supposes you know how many levels of parentage you'll need, and I won't know that (thus the need for a true recurisive query).
Thanks.