Unanswered: How to get list of all store procedures that are related to specific table?
using db2 v9.5 on Linux I would like to get list of all SQL store procedures that are related to specific table.
CREATE PROCEDURE ADMIN.STORE_PROCEDURE
IN INspID INT,
OUT OUTspID INT,
OUT OUTspUSERTYPE CHARACTER (20)
ID = INspID
In the above sample is there any way I could write some select statement against SYSCAT views to get all store procedures where ADMIN.MY_TABLE is included in select/insert/update/delete statement? So answer to this query would be ADMIN.STORE_PROCEDURE, because it includes ADMIN.MY_TABLE in select statement.
Thanks for help. I have managed to write an SQL to get a list of stored procedures that are related to specific table.
SUBSTR(C.ROUTINESCHEMA,1,15) AS PSCHEMA,
SUBSTR(C.ROUTINENAME,1,15) AS PNAME,