Archives of the TeradataForum

Message Posted: Mon, 10 Apr 2006 @ 10:48:54 GMT

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

Hi

This problem is also related to Identity column which is creating a problem.

I use Fastload to load a table. Since I cannot load non empty table, i create a temp table, load it and move data from temp table to target table.

To have the similar definition of the target table for the temp table i create the temp table using this SQL

     create temp table ( select * from target table) with no data;

If the target table consists an Identity column, the create statement gives out error : Error 5788: Message = Create Table As currently do not support Identity Columns

what would be ideal solution to this?

TIA

Satya

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