Archives of the TeradataForum

Message Posted: Tue, 19 Oct 2010 @ 10:20:43 GMT

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

This is nothing specific for timestamps.

There's a difference between NULL and no value, record_end_dtm has a default value, but you want to implicitly insert a NULL, which is prevented by the NOT NULL constraint.

This works:

     insert into DW_STAGING.t1 ();

Dieter

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