IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Relation between Tables and Views in Catalog tables
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
maverick05

New User


Joined: 14 Apr 2005
Posts: 54
Location: Earth
PostPosted: Fri Apr 18, 2008 11:45 am
 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
stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin
PostPosted: Fri Apr 18, 2008 6:09 pm
 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

New User


Joined: 14 Jul 2006
Posts: 93
Location: Chennai,India
PostPosted: Mon Apr 21, 2008 3:01 pm
 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
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 

Similar Topics
Topic Forum Replies
No new posts DB2 Views with Multiple SQL & Col... DB2 8
No new posts Need to fetch data from so many DB2 t... DB2 9
No new posts DASD - non SMS - volser change - VSAM... JCL & VSAM 2
No new posts How to: PK does not exist in several ... DB2 6
No new posts Issue with CA Copycat-IGD17100I UNEXP... CA Products 5
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us