Archives of the TeradataForum
Message Posted: Wed, 03 May 2006 @ 11:26:05 GMT
<-- Anonymously Posted: Wednesday, May 03, 2006 07:27 -->
I have a flat file which contains Japnees data. I need to load in Teradata Using Mload. I have used delimiter and have specified the format as
.Import Infile 'filename' Format vartext '|' Layout InputLayout Apply tagDML and layout is defined .Field DEALER_ID * VARCHAR(30) ; Field COUNTRY_NAME * VARCHAR(180) ;
But mload is inserting junk data into table. I have also specified run time char set as utf8.
Thanx in advance.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|