select distinct PROCNAME
from SYSCAT.PROCEDURES
where SPECIFICNAME in(select dname from sysibm.sysdependencies where bname in ( select PKGNAME from syscat.packagedep where bname=upper('存储过程名')))
and procschema = upper('表空间名');
select distinct PROCNAME
from SYSCAT.PROCEDURES
where SPECIFICNAME in(select dname from sysibm.sysdependencies where bname in ( select PKGNAME from syscat.packagedep where bname=upper('存储过程名')))
and procschema = upper('表空间名');