Hi,
My Job design is like this:
DB2----->Tranformer---->Sequential file
Actually this job is running fine in production daily(In DataStage 7.5-Windows)
Now we are migrating to 8.1-LINUX.
In migration, while doing the testing of this job,it is getting aborted with
below warning.
SQLFetch: Error retrieving results from server.
[IBM][CLI Driver] CLI0002W Data truncated. SQLSTATE=01004
And also the above messages are displaying as "Info" messages.
I tried searching here,but I am unable to find the appropriate solution.
Can any one Please help me on this.
Data truncation warning
Moderators: chulett, rschirm, roy
Data truncation warning
Thank You,
Sudarsan AVS
Sudarsan AVS
You need to find out which column is benig truncated and if it makes a difference. In a test copy, remove the columns one-by-one until you identify which one it is. It might be that, at 8.1, DataStage is more vocal about giving out warnings, meaning that you might have had the problem before, but just never knew about it.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>