Hi

I want to see what is the dependencies on some tables in a DB2 database.
I specificaly want to see which stored procedures are dependent on a table.

thanks

Look in syscat.routinedep.

Andy

Select r.ROUTINESCHEMA, r.ROUTINENAME,r.routinetype,r.specificname,D.BName ,D.BType,pgd.bname
from syscat.routineDEP D,SYSCAT.ROUTINES R, syscat.PACKAGEDEP pgd
where d.SPECIFICNAME = R.specificname and ROUTINETYPE = 'P'
and d.BNAME = pgd.PKGNAME and pgd.BTYPE = 'T'
fetch first 20000 rows only

can anybody tell me if I GOT it

Thanks Winner, is that why your are called Winner,
I have just posted what I think the solution is, maybe you can check if I am a winner as well

I am a Winner because that is my actual name. To see what Stored Procedures are dependent on a table, you only need syscat.routinedep and syscat.routines.

Andy

Thanks for your help