?
Solved

DBQ sql: there a command to print where a view is called?

Posted on 2011-04-28
5
Medium Priority
?
602 Views
Last Modified: 2012-05-11
I have a piramid of view in db2.
Is there a command to print every occurance of a my view?
this because sometime I have to recreate one of them and
drop instruction delete all of them which call it.
0
Comment
Question by:bobdylan75
  • 4
5 Comments
 
LVL 37

Accepted Solution

by:
momi_sabag earned 2000 total points
ID: 35483214
what do you mean by piramid?
views depending on each other?
you have the sysviewdep table that contains these dependencies
0
 

Author Comment

by:bobdylan75
ID: 35483231
YES IT IS,
OK I TRY IT NOW.
0
 

Author Closing Comment

by:bobdylan75
ID: 35483234
thanks
0
 

Author Comment

by:bobdylan75
ID: 35483289
sorry where is this sysviewdep table?
0
 

Author Comment

by:bobdylan75
ID: 35483423
OK IN QSYS2
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses
Course of the Month17 days, 12 hours left to enroll

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question