Search found 2 matches

by kamal2
Wed Dec 03, 2014 9:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Warning: Data has been truncated
Replies: 4
Views: 5856

The message is : WARNING: JOB_NAME.TRANSFORMER_NAME: DSD.BCIPut call to function SQLExecute returned informational message. SQLSTATE=01004, DBMS.CODE=0 [DataStage][SQL Client]Data has been truncated COL1 = "N" COL2 = "1-LWSZXT" COL3 = "S41" COL4 = "Seguridad CONTRA...
by kamal2
Mon Dec 01, 2014 6:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Warning: Data has been truncated
Replies: 4
Views: 5856

Warning: Data has been truncated

Hello, I have a warning in my Job. Warning: Data has been truncated. The job extracts data from Oracle and loads it into SQL Server. When I extract the data I convert it from ms12 to UTF8 because I have a problem with specific characters? The NLS in DataStage is MS1252 and in Oracle AL32UTF8 and UTF...