bobdylan75
asked on
DBQ sql: there a command to print where a view is called?
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks
ASKER
sorry where is this sysviewdep table?
ASKER
OK IN QSYS2
ASKER
OK I TRY IT NOW.