Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 04 May 2010 @ 09:17:00 GMT

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

Subj:   Re: MLoad - Fixed Length Record
From:   Howard Bradley

  Is there an easy way to load a flat file that has fixed length record, but has multiple records on each row?  

Hi Megan

I don't think there is an "easy" way, but if you don't want to write an INMOD or to pre process the file in any way and are restricted to a Teradata utilities solution you could load the data to a large enough CHAR column (if the number of records is known in advance) or VARCHAR column and then use a recursive query to strip out the records to be stored individually as rows on a second table.

Painful, but should work OK with a reasonable number of records :-)



  <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