Re: Informix SQL/4gl Nary Tree Explosion

} } > } > As the title suggests, has anybody tackled such a beast. } > that is, given a employee table } > emp# manager_emp# other columns... } > --- ----------- } > -- } > Burzin N. Engineer |Tel. (310) 524 1800 | email: burzin@twinsun.com } } This method WILL work using a stored procedure (holler if you want an } example), BUT, and it is a very big BUT, IF TWO PEOPLE TRY TO RUN THE } STORED PROCEDURE AT ONE TIME YOUR ENGINE WILL CRASH. This is true on our } engine 5.00.UC1. This bug is fixed in 5.01 and above. Cheers - Jim My opinions are my own. They may vary with time but they remain MINE! ---------------------------------------------------------------------- Name: Jim Gordon Company: DHL Systems Inc, Burlingame, CA, USA ----------------------------------------------------------------------