Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 18 Jan 2011 @ 16:24:04 GMT

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

Subj:   Re: Values input to a Macro
From:   Barner, Eric


I am not exactly sure what features you think are missing from macros? Can you provide and example of a feature you would like to see, or you think is deficient?

I think some of the main purposes for using macros are:

1. To have standardized SQL that can be fed different parameters.

2. Implement code that will be executed frequently (like from an application) to reduce the parsing cost in the DB, since the code is already parsed.

3. Manage complex code, logic or transformations within the DB, rather than in an external tool/code base.

Any procedural type logic can* be implemented in Stored Procedures.

Eric W. Barner

* Author is not advocating casual use stored procedures except in cases where it is absolutely necessary or any the iterative logic is limited to reasonably small loop sizes. Set logic / operations are almost always best.

  <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