Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 14 Apr 2011 @ 11:48:26 GMT


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


Subj:   Error in multiload reading from multiple files
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, April 13, 2011 03:58 -->

Is the below approach the right one for loading data from multiple files in a single go?

     .IMPORT
     INFILE ${filename1}
     FORMAT VARTEXT DISPLAY ERRORS NOSTOP
     LAYOUT LAYOUT_LABEL
     APPLY DML_LABELL;
     .IMPORT
     INFILE ${filename2}
     FORMAT VARTEXT DISPLAY ERRORS NOSTOP
     LAYOUT LAYOUT_LABEL
     APPLY DML_LABEL;
     .IMPORT
     INFILE ${filename3}
     FORMAT VARTEXT DISPLAY ERRORS NOSTOP
     LAYOUT LAYOUT_LABEL
     APPLY DML_LABEL;

Now What happens if load fails while loading 2nd file? When it is restarted, will the load continue from where it stopped?

Also what about records in et1 and et2. Will they get appended after load from each file?


Thanks



     
  <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