Re: Does anyone have a script to display hierarchy of tables starting with a specific one

This is just a related FYI..
In DB2 you get what they call 'Table Expressions' aka 'With' clause. Using this, you can write a recursive sql query that can give you the hierarchy you need.

Srini Venigalla

In article <n3dA4.41$585.157570_at_news.magma.ca>, "Eric" <ebektech_at_videotron.ca> wrote:
> based on the fk-pk relationship...
>
> example:
> employee
> dept
> store
> marital_status
> address
> country
> .
> .
> .
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Mar 17 2000 - 00:00:00 CST