Re: Informix SQL/4gl Nary Tree Explosion

burzin@twinsun.com (Burzin Engineer) writes: > As the title suggests, has anybody tackled such a beast. > that is, given a employee table > emp# manager_emp# other columns... > --- ----------- > >For a particular emp# (node) I want to find all employees/managers >under him whether directly or indirectly (all its children). >Has anybody done this under Informix? There is a chapter in the 4GL BY EXAMPLE book that deals with parts explosion, which should apply here. I haven't looked at it in awhile, but I recall thinking "Yep, that's how *I* would do it" when I read it way back when. The book is part of the set you get when you buy either RDS or c-compiled 4GL, I believe. ======================================================================= Dennis J. Pimple dennisp@informix.com Opinions expressed Senior Consultant -------------------- are mine, and do not Informix Software Inc Voice: 303-850-0210 necessarily reflect Denver Colorado USA Fax: 303-779-4025 those of my employer.