Archives of the TeradataForum
Message Posted: Tue, 07 Oct 2015 @ 00:24:03 GMT
| Subj: || || Re: RDBMS Error code 6706 |
| From: || || Pluebell, Fred |
What character is being presented to Teradata? Most likely it is 0x1A or 0xFFFD which indicates DataStage detected the error in the input stage
and used the "error substitution character" which Teradata does not like. This is a problem that you should try to fix in the input stage, e.g. by
specifying a different NLS code page. If that's not feasible, then add a stage to modify the data and remove the error character before passing it
to the Teradata load stage.