db2 常用语句

 查看sp文本
select text from syscat.procedures where procname='PROC_NAME';

2 查看table结构
describe table syscat.procedures
describe select * from syscat.procedures

3 查看各表对sp的影响(被哪些sp使用)
select PROCNAME
from SYSCAT.PROCEDURES
where SPECIFICNAME in
(select dname
 from sysibm.sysdependencies
 where bname in
 ( select PKGNAME  from syscat.packagedep where bname='TB_BRANCH'))

4 查看sp使用了哪些表
select bname
from syscat.packagedep
where btype='T' and pkgname in
(select bname
 from sysibm.sysdependencies
 where dname in
  (select specificname
   from syscat.procedures
   where procname='PR_CLEAR_MATCH_DIVIDE_SHA'))

5 查看function被哪些sp使用
select PROCNAME
from SYSCAT.PROCEDURES
where SPECIFICNAME in
(select dname
 from sysibm.sysdependencies
 where bname in
 ( select PKGNAME
   from syscat.packagedep
   where bname   in
   (select SPECIFICNAME from SYSCAT.functions where funcname='GET_CURRENT_DATE')))

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12315270/viewspace-598406/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12315270/viewspace-598406/