Data truncation warning

sudarsan · Post by **sudarsan** » Thu Sep 10, 2009 12:16 am

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.

ArndW · Post by **ArndW** » Thu Sep 10, 2009 12:31 am

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.

sudarsan · Post by **sudarsan** » Thu Sep 10, 2009 12:48 am

Thanks a lot for quick reply.

I will try this and let you know.