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.

Thanks

Sandipan