Archives of the TeradataForum

Message Posted: Wed, 27 Oct 2010 @ 10:06:06 GMT

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

Hi use on commit preserve rows you should see the data

     create volatile table testvolatile
     as  (select  * from database.tab1    sample 10        )
     with data
     ON COMMIT PRESERVE ROWS;
     ;

Regards,

Anshuman Singh

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