Query on system tables to retrieve views with table as input

shankar.v · Posted: Wed Mar 28, 2012 8:40 pm

I have table as input. I would like to have query on system tables which output list of views defined using the table passed as input. In the output, I would like to have the views in output which defined from view (which defined from table) too.

for example, Let say tables t1,t2,t3,t4

View v1 is defined as follows.
select * from t1,t2 where ...

View v2 is defined as follows
select * from v1,t3 where ...

View v3 is defined as follows
select * from v2,t4 where ...

Note: For all views v1,v2,v3 one of the underlying table is t1

Input:
T1

Output:
V1
V2
V3

Pandora-Box · Posted: Thu Mar 29, 2012 11:14 am

I am not sure if you are going to use it within the program but if you have tools like IBM ADMIN TOOL,BMC or PLATINUM you can the views associated to a table

GuyC · Posted: Thu Mar 29, 2012 1:02 pm

Checkout table SYSIBM.SYSVIEWDEP

shankar.v · Posted: Fri Mar 30, 2012 2:57 pm

Thank you GuyC. I would able to get the solution for my question using system table SYSIBM.SYSVIEWDEP.