Archives of the TeradataForum

Message Posted: Sat, 23 May 2009 @ 21:31:24 GMT

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

Hanumath:

As I mentioned to you earlier on this same subject, a macro is a transaction and DDL must be the last thing in the transaction. As long as you create the volatile table with preserve rows, you can access it after the macro is executed. However, you cannot access it in the same macro or even a macro executed from the first macro because they are a transaction. If you want a lot of additional processing on the volatile table, create a second macro to handle it and kick it off only on successful execution of the first macro - called job control.

Regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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