How to find the perticular view has been defined

umed · New User Joined: 13 May 2005 Posts: 40

Hi,

How can we find the tables on which a perticular view has been defined.Here we are having only name of that view with us.

Regards,
Umed

DavidatK · Posted: Thu Dec 22, 2005 3:23 am Post subject:

If you have DB2 FileAid. use option 3.4, then option GD to display the view.

senthilssg · Active User Joined: 09 Dec 2005 Posts: 55

Hi umed,

you can get the table name by getting informattion from the sysibm.sysviews catalog table.

execute the query in the following format in QMF or in SPUFI

SELECT NAME ,TEXT FROM SYSIBM.SYSVIEWS WHERE NAME ='view name '

In output of above query , TEXT column having declaration of that view . from that you can know corresponding table for that given view

Eg:

NAME TEXT
------------------ ---------------------------------------------
EMPLOYEE_VIEW create view employee_view (id ,name, sal) as select emp_id , emp_name,emp_sal from ssgsen.employee;

In that example , table name for the view EMPLOYEE_VIEW is ssgsen .employee;