Re: pointers on representing tree in db?

From: Srinivas Venigalla <svenigal_at_rochester.rr.com>
Date: Thu, 19 Apr 2001 12:52:55 GMT
Message-ID: <HcBD6.115$rk.133188@typhoon.nyroc.rr.com>

Lennart Jonsson <lennart_at_kommunicera.umea.se> wrote in message news:3adc922a$1_at_news.kommunicera.umea.se... >
> Quite neet feature. Oracle seems to have a lot of things that DB2 doesnt.
I
> am however more interested in "classical" work using only standard SQL.
The
> solution I came up with is to use two tables

I am not sure which features of Oracle you are referring to. DB2 has the "With" clause that enables you to write recursive queries to retrieve the parent-child relationships (Difficulty with trees is not creating them, but retrieving them using sql).
This feature is there since UDB5.X The UDB SQL Reference has a very good documented example covering the very popular Bill-Of-Materials problem. Received on Thu Apr 19 2001 - 07:52:55 CDT