Archives of the TeradataForum

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

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

<-- 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>>