Finding dependencies in stored procedures

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Praveen_db2 - 24 Jul 2006 16:38 GMT

Hi All
DB2 8.1.3, Windows

Is there any method to find the routines dependant on any particular
routine.
Say, I have a stored procedure PROC1 which calls 2 stored procedures and
is called by 3 stored procedures.
Is there any method to find the names or atleast packages of these stored
procedures which are called by PROC1 and are calling PROC1?
Is something there in SYSCAT.ROUTINEDEP or SYSCAT.PACKAGEDEP which can be
manipulated for this?

Regards
Praveen

Reply to this Message

Serge Rielau - 24 Jul 2006 17:09 GMT

> Hi All
> DB2 8.1.3, Windows
[quoted text clipped - 7 lines]
> Is something there in SYSCAT.ROUTINEDEP or SYSCAT.PACKAGEDEP which can be
> manipulated for this?

What are you missing? These two views should do the job as is.

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ondemandbusiness/conf2006/

Reply to this Message

jefftyzzer - 24 Jul 2006 19:08 GMT

This may get you a little further with respect to the SP + Package
relationship:

SELECT
    R.ROUTINESCHEMA,
    R.ROUTINENAME,
    P.PKGNAME
FROM
    SYSCAT.ROUTINES R,
    SYSCAT.ROUTINEDEP RD,
    SYSCAT.PACKAGES P
WHERE
    R.ROUTINESCHEMA = RD.ROUTINESCHEMA
AND
    R.SPECIFICNAME = RD.ROUTINENAME
AND
    RD.BNAME = P.PKGNAME
ORDER BY
    1,
    2;

> Hi All
> DB2 8.1.3, Windows
[quoted text clipped - 10 lines]
> Regards
> Praveen

Reply to this Message