Archives of the TeradataForum

Message Posted: Wed, 15 Jul 2009 @ 22:16:16 GMT

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

Instead of defining your identity column as "generated always" you should define it as "generated by default". This will allow you to supply the value as a literal as your insert indicates you are doing. See chapter 3 of the SQL Reference Manual in the section covering "identity" columns.

Regards,

John Dobbins
KDJ Technology, LLC

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