General discussion
March 18, 2002 at 08:50 PM
kgorman1

Recursive SQL for DB2 v6.x

by kgorman1 . Updated 24 years, 6 months ago

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.

This discussion is locked

All Comments