Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Need description of View

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 680
Location: NJ

PostPosted: Mon Mar 20, 2006 5:47 pm    Post subject: Need description of View
Reply with quote

Hi all,

Can any one plz help me to know the description of the view in DB2.. Ie.., i wanna to know what are all the tables related in that particular view. I tried with SYSIBM.SYSVIEWS and other tables but it shows only.

Create view viewname where (............)

but i wanna the description of that view.. Can any one help me. ThX in Adv. icon_smile.gif
Back to top
View user's profile Send private message

martin9

Active User


Joined: 01 Mar 2006
Posts: 290
Location: Basel, Switzerland

PostPosted: Mon Mar 20, 2006 6:38 pm    Post subject:
Reply with quote

hy khamarutheen,

if you go into the DB2 Administrator,
you select any db2-view and you choose T for
viewing all related tables to that db2-view.
ISPF Primary Option Menu -> G.D.2.A

martin9
Back to top
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 680
Location: NJ

PostPosted: Tue Mar 21, 2006 5:43 pm    Post subject: View description
Reply with quote

Hi Martin,

I cant get u what u r trying to say... but meanwhile i got the solution. ie., i was checking in SPUFI env. once i tried the SELECT option of SYSIBM.SYSVIEWS on QMF i got the result what i expected. Hope u r saying in alternative way. Plz give in detail let us all know more about that. icon_wink.gif
Back to top
View user's profile Send private message
ragshere

New User


Joined: 20 Dec 2004
Posts: 70

PostPosted: Thu Mar 23, 2006 11:16 am    Post subject: Re: Need description of View
Reply with quote

Hi,
You can get the tables list for a view by querying SYSIBM.SYSVIEWDEP.



Thanks,
Rags
Back to top
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 680
Location: NJ

PostPosted: Thu Mar 23, 2006 6:22 pm    Post subject: View description
Reply with quote

Hi Rags,

Thanks i too tried with that also. V have alternative way. Thank once again. Can u get what martin was trying to say??? If so plz let me know in detail icon_cool.gif
Back to top
View user's profile Send private message
ragshere

New User


Joined: 20 Dec 2004
Posts: 70

PostPosted: Mon Mar 27, 2006 12:14 pm    Post subject: Re: Need description of View
Reply with quote

Hi khamarutheen,
Martin is asking you to use IBM supplied DB2 admin tool to view the tables involved in a view. Even that tool will get the details from SYSTABLES and SYSVIEWDEP only.

so you will get the same result either from DBA tool or from querying the catalog deirectly.

Hope you got me.

Regards,
Rags
Back to top
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 680
Location: NJ

PostPosted: Tue Mar 28, 2006 5:19 pm    Post subject: View Description
Reply with quote

Hi Rags,

Thank u. Any way using the query will help in most of the situation since many may not use this tool. icon_smile.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts REXX to view the PGM or PROC jackzhang75 CLIST & REXX 11 Tue Jun 20, 2017 1:20 am
No new posts How to see VIEW definition from BMC c... rohanthengal DB2 1 Thu May 04, 2017 1:50 pm
No new posts TWS EQQYCAIN - not sure how to get ap... mbenaud IBM Tools 0 Wed Dec 14, 2016 8:45 pm
No new posts Help Needed with View Direct shailesh_do CA Products 2 Wed Jul 13, 2016 10:39 am
No new posts how to find clist's or view library Andrew Hsia CLIST & REXX 4 Tue Jun 28, 2016 6:07 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us