In our development and test environments, it is very common for a view to be created and then the underlying object changed or dropped. This renders the view invalid and any action attempted with it results in one of the following errors: *** Failure 3807 Object '___' does not exist. *** Failure 3810 Column/Parameter '___' does not exist.
Is there some way to query the data dictionary to find these invalid views? Having a maintenance script that tries to access every view in the database seems horribly inefficient.
There is no straight forward answer to your problem How ever i used to generate dynamic sql statements for each view like sel * from view1 where 1 = 2; I used put all this in bteq script. use ''.SET ERROROUT STDOUT;" after your .log on credentials. When you run the script and open your log file you will find where ever you see those errors numbers, those are the INVALID vws Hope this helps Ranga