Re: pointers on representing tree in db?
Date: Thu, 19 Apr 2001 12:52:55 GMT
Message-ID: <HcBD6.115$rk.133188_at_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 - 14:52:55 CEST