Archives of the TeradataForum

Message Posted: Fri, 21 Mar 2003 @ 18:42:38 GMT

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

Yes, that is correct. One way to do this is to fastload two separate tables, one with "default" value and the other with not null, non- default (actual) values. Then merge the two tables with an optimized insert/select (table merge) into final target table.

One other possibility is to convert a null input value to the tables default value in the VALUES input stream using the COALESCE function...

Insert into TableA (col1,col2, col3)
values (
:in_col1
, coalesce (:in_col2, "default_value")
, :in_col3
);

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