In the Data Studio product if where would I look to find the packages that a table is used in? It'd approximately correspond to this query
select grantee, insertauth,selectauth,deleteauth,updateauth
from sysibm.systabauth where ttname = 'TABLE_NAME' and Tcreator = 'TCREATOR' and granteetype = 'P'
This topic has been locked.
7 replies Latest Post - 2013-04-03T21:21:26Z by sumithar
Pinned topic packages a table is used in
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-04-03T21:21:26Z at 2013-04-03T21:21:26Z by sumithar
CatherineWu 0600001TD811 PostsACCEPTED ANSWER
Re: packages a table is used in2013-03-07T07:34:00Z in response to sumitharHi,
You can try this with Data Studio v3.2. In Administration Explore, click "table". Right click the table you want to search in OLE, click "impact analysis..." in context menu. Then you will see all impact objects and after you order by object type, you will see list of packages.
YuanFeng 2700030G5D78 Posts
Re: packages a table is used in2013-04-02T19:45:08Z in response to YuanFengHi Yuan Feng,
This is what I did, right clicked on table name
When I do that I get a list of indexes and such like, still no packages.