Search found 62 matches
- Fri May 07, 2010 8:16 am
- Forum: General
- Topic: [DataStage][SQL Client]Data has been truncated
- Replies: 6
- Views: 4695
Welcome aboard. I can only suggest search harder. Could it be decimal numbers with rightmost decimal places being truncated? Perhaps your DBA could enable a higher level of tracing while you solve it. Ray, Thank you for your response. To isolated the problem, I limited the transforms to only non-nu...
- Thu May 06, 2010 2:31 pm
- Forum: General
- Topic: [DataStage][SQL Client]Data has been truncated
- Replies: 6
- Views: 4695
[DataStage][SQL Client]Data has been truncated
All, When I run a DataStage job to load an Oracle table, the data gets written to the table, but for each record written I get the following warnings: SQLSTATE=01004, DBMS.CODE=0 [DataStage][SQL Client]Data has been truncated SQLSTATE=01004, DBMS.CODE=0 [DataStage][SQL Client]Data has been truncated...