DB2 AIX: Stored Procedure Dependency Script

[ARK]

Some stored procedures call other stored procedures. When moving
stored procedures as part of a release this requires that you create
the children procedures before the calling procedures.

Is there a tool, script, or some other way to determine the dependency
list?

[ARK]

I hate to answer my own question as I thought it was more difficult
than this:

select R.ROUTINESCHEMA , R.ROUTINENAME AS SPECIFICNAME, X.ROUTINENAME,
rtrim(
p.bschema) || '.' || P.bname as DEPON
from syscat.PACKAGED EP P, syscat.ROUTINED EP R, syscat.routines X
where P.bschema = 'yourschema'
and p.btype = 'F'
and P.PKGNAME = R.BNAME
and P.PKGSCHEMA = R.ROUTINESCHEMA
and R.BTYPE = 'K'
and R.ROUTINENAME = X.specificname
and R.ROUTINESCHEMA = X.ROUTINESCHEMA
and X.valid = 'Y'
and X.routinetype = 'P'
and p.bschema||P.bn ame in (
Select Z.ROUTINESCHEMA ||Z.specificnam e
from syscat.routines Z
where Z.routinetype = 'P'
group by Z.ROUTINESCHEMA , Z.specificname )
order by R.ROUTINESCHEMA , R.ROUTINENAME;