Archives of the TeradataForum

Message Posted: Thu, 27 May 2004 @ 13:22:23 GMT

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

Hi,

Use,

     CREATE MULTISET VOLATILE TABLE A AS(

         SELECT Statement
         ) with data on commit preserve rows;

The problem is duplicate row check.

Regards.

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