找DB2存储过程的package

最新推荐文章于 2021-05-14 04:32:24 发布

转载最新推荐文章于 2021-05-14 04:32:24 发布 · 1.3k 阅读

2 ·

CC 4.0 BY-SA版权

原文链接：https://my.oschina.net/solarxie/blog/481494

文章标签：

#python #数据库

2019独角兽企业重金招聘Python工程师标准>>>

The query you can use to determine the stored procedure names differs depending on your version of DB2 UDB.

For DB2 UDB Version 8.1, use the query:
select pkgschema,pkgname,procname, boundby, definer from syscat.packages a, syscat.procedures b where a.pkgname = substr(implementation,1,8)

Sample output:
PCKGSCHEMA PKGNAME PROCNAME ---------- --------- ----------- DB2INST1 P9520507 SP_INSERT

For DB2 UDB Version 8.2 or higher, use the query:
select procschema, procname, bname as packagename from
syscat.procedures, syscat.routinedep where
syscat.procedures.specificname=syscat.routinedep.routinename

Sample output:

PROCSCHEMA PROCNAME PACKAGENAME
---------- --------- -----------
DB2INST1 SP_INSERT P9520507