–根据表名查找存储过程(不加模式名)
SELECT PROCSCHEMA, –模式名
PROCNAME –存储过程名
FROM SYSCAT.PROCEDURES
WHERE SPECIFICNAME IN (SELECT DNAME
FROM SYSIBM.SYSDEPENDENCIES
WHERE BNAME IN (SELECT PKGNAME
FROM SYSCAT.PACKAGEDEP
WHERE BSCHEMA = ‘APP_FAT’ –模式名
AND BNAME = ‘APPAUTFEE’ –表名
))
DB2 根据表名查找存储过程
最新推荐文章于 2021-09-23 11:44:55 发布