View previous topic :: View next topic
|
Author |
Message |
Anand78
New User
Joined: 06 Mar 2006 Posts: 50 Location: PUNE
|
|
|
|
I want to know what are all tables used in a particular program.
Using TSO DB2LIST , it will not give table names that r used in includes ?
Thanks in advance
ANAND[/b] |
|
Back to top |
|
|
amitava Warnings : 1 Active User
Joined: 30 Oct 2005 Posts: 186 Location: India
|
|
|
|
Hi Anand87,
Look what ur requirement is that can not be solved by a command(I think so). So the way to meet ur requirement is to code a REXX routine which will go through each program and it will find out the tables used in that program.
If you need the code, I can send u. |
|
Back to top |
|
|
ragshere
New User
Joined: 20 Dec 2004 Posts: 70
|
|
|
|
Hi Anand,
use this below query for getting the tables/views/aliases using in a program.
If you are using packages
select bname from sysibm.syspackdep
where dname= <program name>
and bqualifier=<db2 owner of the tables>
Here you can comment out last condition if needed.
If you are not using packages, use SYSIBM.SYSPLANDEP instead of SYSIBM.SYSPACKDEP.
If you get any errors, do let me know.
Thanks
Rags |
|
Back to top |
|
|
|