Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Anbody capture redundant object information
 
From:   Joseph D silva

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016