Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
Relation between Tables and Views in Catalog tables

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
Author Message
maverick05

New User


Joined: 14 Apr 2005
Posts: 35
Location: Hyderabad,India
PostPosted: Fri Apr 18, 2008 11:45 am    Post subject: Relation between Tables and Views in Catalog tables
 Reply with quote
Hi,

I have a table which has some x number of views.Is thier any SYSIBM catalog tables where can i find the list of Views mentioned against the table or how to find the same?

TIA
Back to top
View user's profile Send private message
References
stodolas

Senior Member


Joined: 13 Jun 2007
Posts: 647
Location: Wisconsin
PostPosted: Fri Apr 18, 2008 6:09 pm    Post subject:
Reply with quote
If you can run the DB2 admin tool you can fine it, but that just pulls info from the SYSIBM tables. You should be able to find one. Have you looked in the manuals for it?
Back to top
View user's profile Send private message
skkp2006

Active User


Joined: 14 Jul 2006
Posts: 68
Location: Chennai,India
PostPosted: Mon Apr 21, 2008 3:01 pm    Post subject: Reply to: Relation between Tables and Views in Catalog table
 Reply with quote
Maverick,

Have a look at SYSIBM.SYSVIEWDEP table.

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2.doc.sqlref/zvwdep.htm



Syam
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1