Archives of the TeradataForum
Message Posted: Fri, 26 Nov 2010 @ 20:50:40 GMT
| 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
| 
