Gert van der Kooij wrote:
In article <at*************@fe03.lga>, rs**********@charter.net says...
From a table like the one below, is there an easy (ha ha) way to get a
set level of pedigree (3 or 5 generations, say?).
One of my favorite replies :)
Download (and read) the DB2 UDB Cookbook from Graeme Birchall (page 299,
recursive queries) from
http://mysite.verizon.net/Graeme_Birchall/id1.html
Thank you for the reply/pointer.
While I only read the recommended chapter, I would recommend it to any
one using DB2. It is clearly written, with copious examples.
The given solutions, as I read the chapter, contain 1 row for each
individual in the ancestor tree. What if I want 1 row for the scion with
all of the ancestors, perhaps in some given order?