|
View previous topic :: View next topic
|
| Author |
Message |
mohanrazz
New User
Joined: 30 Sep 2008
Posts: 30
Location: India
|
|
|
|
Hi all,
I have small query. I would like to find out all the views that are associated with a particular DB2 Table. Can anyone pls tell me how i can do that.
Thanks in advance. |
|
| Back to top |
|
 |
ksk
Active User
.jpg)
Joined: 08 Jun 2006
Posts: 355
Location: New York
|
|
|
|
| What tools you have in your organization? Using Platinum tool you can find the details. |
|
| Back to top |
|
|
mohanrazz
New User
Joined: 30 Sep 2008
Posts: 30
Location: India
|
|
|
|
ksk,
We have DB2 File manager in addn to spufi |
|
| Back to top |
|
|
ashimer
Active Member
Joined: 13 Feb 2004
Posts: 551
Location: Bangalore
|
|
|
|
Query on SYSIBM.SYSVIEWS ...
| Code: |
SELECT NAME FROM SYSIBM.SYSVIEWS WHERE TEXT LIKE '%tbname%'
|
|
|
| Back to top |
|
|
mohanrazz
New User
Joined: 30 Sep 2008
Posts: 30
Location: India
|
|
|
|
| ashimer, thanks. |
|
| Back to top |
|
|
|
|
