Columnvalue in unix file truncated and rejected
Posted: Fri May 04, 2007 1:23 am
Hello,
Can someone help me with the following problem:
I have a unix sequential file (NLS ISO8859-1). The euro sign in the file is shown as a question mark when i view data in datastage (because of the NLS setting). The length of the column is 100 positions and is written to an oracle table (NLS UTF8) to a VARCHAR2(100 CHAR) column.
Nevertheless, I still get the next two warnings:
-----------
Value "In 2002 bedroeg de afkoopwaarde ? 1.471,08. In 2006 bedraagt deze ? 680,00. Er is voor ? 3.833,8..." truncated to "In 2002 bedroeg de afkoopwaarde ? 1.471,08. In 2006 bedraagt deze ? 680,00. Er is voor ? 3.833,8.."
InterfaceKMSKlachtData..InlezenData: At row 733, link "DataOra"
Inserted value too large for column, row rejected.
-----------
I hope someone has a solution.
Can someone help me with the following problem:
I have a unix sequential file (NLS ISO8859-1). The euro sign in the file is shown as a question mark when i view data in datastage (because of the NLS setting). The length of the column is 100 positions and is written to an oracle table (NLS UTF8) to a VARCHAR2(100 CHAR) column.
Nevertheless, I still get the next two warnings:
-----------
Value "In 2002 bedroeg de afkoopwaarde ? 1.471,08. In 2006 bedraagt deze ? 680,00. Er is voor ? 3.833,8..." truncated to "In 2002 bedroeg de afkoopwaarde ? 1.471,08. In 2006 bedraagt deze ? 680,00. Er is voor ? 3.833,8.."
InterfaceKMSKlachtData..InlezenData: At row 733, link "DataOra"
Inserted value too large for column, row rejected.
-----------
I hope someone has a solution.