DB2数据库查看表和存储过程、触发器的写入关系

--根据表名称，查询出和这个表有关系的存储过程名称及存储过程代码

--PROCDURE
SELECT A.BNAME AS TABNAME,A.ROUTINENAME AS OBJECT_NAME,B.TEXT FROM SYSCAT.ROUTINEDEP A
INNER JOIN SYSIBM.SYSROUTINES B ON A.ROUTINENAME=B.ROUTINENAME
WHERE A.ROUTINESCHEMA='DB2INST1'
AND A.BTYPE='T'
AND A.BNAME=upper('rpt_analog_maxmin_data')
UNION ALL
--TRIGGER
SELECT T.TABNAME,TRIGNAME AS OBJECT_NAME,T.TEXT FROM SYSCAT.TRIGGERS T
WHERE T.OWNER ='DB2INST1'
AND TABNAME=upper('rpt_analog_maxmin_data')