Archives of the TeradataForum

Message Posted: Wed, 07 Oct 2015 @ 19:14:48 GMT

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

<-- Anonymously Posted: Wednesday, October 07, 2015 13:24 -->

Hi,

The source field is a Char field. The data in the field has an "accented" character. It is actually an 'I' with a tick on top. When read by DataStage it is being converted and displayed as a '?' in DataStage. However, when I dumped the data in a Unix file and did an "octal-dump" on the file, it should a hex value of 032. I looked up the internet and found that it was the "substitute" (SUB) character and is being rejected by Teradata.

I suspect this is the data that is being rejected because this record gets loaded to the Teradata Error1 table and the Error1 table indicates this field as the cause of the error.

Thanks.

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