Can anybody tell me how to findout the hierachy relation (dependencies) ?

My situation is, I have 500 tables and I need to delete some records in all tables so I would like to know from which table I have start because I blindly started with one table it is saying the parent table record can not be deleted.

Please give some idea

I think the information you need is in SYSCAT.REFERENCES

Visit http://www.db2click.com/scribble.htm ... There is an SQL on this page which will list table dependencies

Cheers
Sathyaram

There need not be a strict table hierarchy, since tables may circularly reference each other.
A table may even reference itself, e.g., an "employees" table with a column "direct supervisor".

-- Peter Vanroose.