extract dependences with db2look

georgipa · #1 (**permalink**) 08-24-11, 07:13

Hi colleagues,

I need to extract the objets than depend for a table with db2look.

Thank you for you help.

przytula_guy · #2 (**permalink**) 08-24-11, 07:19

you mean with foreign keys ?? or indexes or ??
these can be found also in syscat views..

Mathew_paul · #3 (**permalink**) 08-24-11, 08:20

if for foreign key, parent table db2look won't we ddl for child, find the child tables thru syscat.references and then run db2look on child table for DDL.

regds
Paul

georgipa · #4 (**permalink**) 08-24-11, 09:02

Hi,
In the command db2look -d database there are not the option for to extract dependencs?

Thank you.

Internet Services

Web Development

Digital Marketing

Consumer Tech