Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: RDBMS Error code 6706
From:   Anomy Anom

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


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.


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 24 Jul 2020