Archives of the TeradataForum
Message Posted: Tue, 06 Oct 2015 @ 21:24:05 GMT
<-- Anonymously Posted: Tuesday, October 06, 2015 13:15 -->
I am trying to load a data file from Mainframe to Teradata using DataStage using Fastload. The input data comes as a EBCDIC file and has certain control characters that gets converted by DS but fails to load to Teradata and the DS job aborts after inserting some records to the Error1 table with Error code 6706.
I dumped the data into a Unix file (via DS) and ran a od -bc on the file and found that the control character (0x32) appears in certain fields which is actually preventing the rows from loading to the table.
The column in the Teradata table is defined as Character Set LATIN. I tried changing the column character-set from latin to Unicode in the table definition but it did not work.
The requirement is to load those records to Teradata anyway. Is there any way I could make Teradata accept such control characters and would allow to load them from the file via DataStage using Fastload as-is ?
In DataStage I have set UTF-8. I am using DS v9.1 and Teradata v 14.10.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|