Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: Fastload and default values
From:   McBride, Michael

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 (
, coalesce (:in_col2, "default_value")
, :in_col3

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020