Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 26 Nov 2010 @ 20:50:40 GMT


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


Subj:   Re: Pros and Cons of Stored Procedures
 
From:   John_Wight

  Michelle Wrote: JK -- would you be willing to share that stored procedure for generating the collect statistics statements?  


John Hall will have a file out on the TeradatForum web site named TDATA_ADWStats_Source.ddl. The file contains the objects needed to use the process I referred to. In the SPL code, you can see examples of both 'parallel and sequential' SQL. The 'Parallel' is the population of the GT table for those tables qualifying for stats collection. Then there is a CURSOR loop that goes through each row in the GT table to collect stats on the qualifying tables as well as logging trace data in the supporting meta data tables.

Mike and Dieter also made some good points about SPL. AGAIN - SPL is another great tool that can be used in the proper places. I know there are customers that use SPL extensively for ETL processing and other aspects very effectively. I believe in TD 13 (not sure if 00 or 10) there is a facility that will let the Proc send a 'signal' to the calling process that you can use to communicate errors, etc. We're just on 13 but haven't had a chance yet to see if it's in 13.00 or try it out. BUT, will be using it when available.


JK



Admin Comment: The attachment can be found at:

www.teradataforum.com/attach.htm



     
  <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: 15 Jun 2023