Archives of the TeradataForum

Message Posted: Wed, 27 Oct 2010 @ 09:42:18 GMT

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

Hi

You are missing the "on commit preserve rows" clause. Please see example below:

     CREATE VOLATILE TABLE f
     AS (SELECT * FROM dbc.dbcinfo)
     WITH DATA
     ON COMMIT PRESERVE ROWS;

     select * from f;

You should see data!

Regards

Frank

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