DB2 Version :- 8.1 OS - Windows/Linux

From which table i can retrive the object's dependencies in DB2 ? which should list the name of the objects and the order of other object dependenices with it.

For example it I have created a table which contains foreign key relation with other table which references another table is said to be dependent on that table. Or Execution of one procedure might call another procedure, some table insertion/deletion/updation and hence dependent.

How can I find out the list of dependent objects for a particular object.?

You need to look in all these SYSCAT views to get all the dependencies:

CONSTDEP
FUNCDEP
INDEXDEP
INDEXEXTENSIONDEP
PACKAGEDEP
ROUTINEDEP
TABDEP
TRIGDEP
VIEWDEP
XMLOBJECTRELDEP
XMLOBJECTXMLDEP

Refer to the SQL Reference Manual Vol 1 for what is exactly in each.

HTH

Andy