Archives of the TeradataForum

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

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

David,

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>>