Search found 62 matches

by Seyed
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...
by Seyed
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...