Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 04 May 2010 @ 08:50:08 GMT

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

Subj:   Re: MLoad - Fixed Length Record
From:   Mishra, Sandipan

Megan Watson wrote:

  Is there an easy way to load a flat file that has fixed length record, but has multiple records on each row? My file is basically one very long record, but needs to be loaded into the table as multiple smaller records.  

There are two options you probably can use to load unformatted data. Check ".IMPORT FORMAT UNFORMAT" in the manual also there is something called CONTINUEIF. Check if you can use this. If you can send sample row/rows and script it would be helpful to see.



  <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