Archives of the TeradataForum

Message Posted: Thu, 21 May 2009 @ 19:04:01 GMT

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

Hi Prasad,

I am not getting any error message when creating a volatile table at the end of the macro :

Sample Macro:

     replace macro m12
     as
     (
     create volatile table temp1 as (select * from temp_del )
     with data
     on commit preserve rows;
     )

May be the other statements which follow after the creation of volatile table can be kept in another macro and call that one in your stored procedure.

Thanks

Sirisha

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