Archives of the TeradataForum
Message Posted: Tue, 04 May 2010 @ 09:17:00 GMT
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 :-)
|Copyright 2016 - All Rights Reserved
|Last Modified: 15 Jun 2023