|
View previous topic :: View next topic
|
| Author |
Message |
ramanindya55
New User
Joined: 23 May 2008
Posts: 9
Location: pune
|
|
|
|
Hi ,
I need to list down all programs or modules using a given DB2 table. Please let me know how to write a query for this. |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
It is not likely that a query will do what you want. . .
Suggest you look into searching the source code. |
|
| Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA
|
|
|
|
| SYSTABAUTH will tell you who has access to the tables and what that access is. Once that is known you'll need to follow Dick's suggestion and search the source code. |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
| your can always search the dbrms. more difficult if the dbrms are UTF8 but it can be done. |
|
| Back to top |
|
|
|
|
