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.