T-REXDB2
New User
Joined: 28 Apr 2005 Posts: 11 Location: USA
|
|
|
|
sunil_chappy wrote: |
How i know how many and which tables are used in my cobol program.
And i have DB2 table name ..wants to know which-2 and how many programs are using that table. |
Hello, Sir!
Answer is elementary: Query one of two DB2 catalog tables - SYSPLANDEP (i.e., for DBRM bound plans) and/or SYSPACKDEP (i.e., for DBRM bound package, a.k.a., program), using BNAME (object name plan or package depends on) predicate in WHERE clause.
HOPE THIS HELPS, MUCHLY!!! ;-] |
|