Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 19 Oct 2007 @ 21:51:11 GMT

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

Subj:   Re: 2 infiles in Multiload
From:   Dieter Noeth

Kamin Shah wrote:

  Can I specify 2 input files in multiload? I have 2 files with exactly the same layout. I need to insert both of those into the same table. Can I have 2 files in the ?import infile? statement?  

No, but you can use up to 4 IMPORTs.

  If yes, could you please include an example.  

Check the IMPORT syntax in MLoad manual.


  <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: 15 Jun 2023