Need description of View

khamarutheen · Active Member Joined: 23 Aug 2005 Posts: 677 Location: NJ

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.

martin9 · Posted: Mon Mar 20, 2006 6:38 pm

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

khamarutheen · Active Member Joined: 23 Aug 2005 Posts: 677 Location: NJ

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.

ragshere · New User Joined: 20 Dec 2004 Posts: 70

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

Thanks,
Rags

khamarutheen · Active Member Joined: 23 Aug 2005 Posts: 677 Location: NJ

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

ragshere · New User Joined: 20 Dec 2004 Posts: 70

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

khamarutheen · Active Member Joined: 23 Aug 2005 Posts: 677 Location: NJ

Hi Rags,

Thank u. Any way using the query will help in most of the situation since many may not use this tool.