Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 20 Mar 2003 @ 20:12:29 GMT


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


Subj:   Multiload and Date fields
 
From:   Dan Homer

I'm trying to load a flat file into Teradata which includes some Julian dates. Unfortunately, in some of my data files, the dates are invalid and gets dumped to the error table during load. I'd like to nullify invalid dates so the rest of the record can load properly.

I realize one workaround would be to load the date to a character field, then clean out the invalid dates using sql, but am interested on what workarounds are available upon loading in Multiload, rather than afterwards.

Any suggestions/help would be greatly appreciated!

Dan Homer
Systems Integrator
Bull Services



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