Can any one help me to find out dependent sps in DB2..

Thnks in advance

syscat.Routinedep ? Not very sure though

ya got it satya ...


This is the query ..



SELECT SYSROUT.ROUTINENAME
FROM
(
SELECT PKGDEP.BNAME
FROM SYSCAT.PACKAGEDEP PKGDEP,
SYSIBM.SYSDEPENDENCIES SYSDEP,
SYSIBM.SYSROUTINES SYSROUT
WHERE PKGDEP.PKGNAME = SYSDEP.BNAME
AND SYSDEP.DNAME = SYSROUT.SPECIFICNAME
AND PKGDEP.BSCHEMA = SYSROUT.ROUTINESCHEMA
AND SYSROUT.ROUTINENAME = 'SP_DEPEND'
AND SYSROUT.ROUTINETYPE = 'P'
AND PKGDEP.BTYPE = 'F'
) DEP,SYSIBM.SYSROUTINES SYSROUT
WHERE SYSROUT.SPECIFICNAME = DEP.BNAME
AND SYSROUT.ROUTINETYPE = 'P'