Archives of the TeradataForum

Message Posted: Fri, 11 Dec 2009 @ 23:45:36 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

For views, we run a shell that generates a bunch of explain select * from and bteq commands .if errorcode <> 0 stuff and insert the errored view names into a volatile table.

Then at the end of everything generate a select * from the volatile table. If you want detail errors, you can further do a explain select * just for those views and dump into a log file.

We don't have much proc and macros as part of app code ...

probably you can do an explain on the macro ddls and apply the same logic as before.

As far as SPs goes ... how about doing some alter recompile and do the same logic ..

just my $0.02

Joseph D'silva

	<Prev	Next>		<<First	<Prev	Next>	Last>>