Data getting trucated in DB2 Connector

Nagin · Post by **Nagin** » Fri Dec 21, 2012 4:06 pm

Hi, I have job that runs a query on DB2 and dumps the data in to a dataset. One of the columns has data like this - "abc & def" and when extracting data datastage is truncating the data after the & character.

Another strange thing is it is not always truncating the data that comes after & some times it is truncating data that is before the ampersand &.

For example, one row with value abc & def it is displaying only abc and for another row with values xyz & zdc it is displaying xyz .

Have you seen this problem before? Is there any setting I need to enable for this?

Thank you.

ray.wurlod · Post by **ray.wurlod** » Sat Dec 22, 2012 12:33 am

In both your examples you are getting the data BEFORE the ampersand. What data types are involved?
Are the data being truncated in View Data, or in the job itself (that is, what is the output of the job)?
Are there any non-printing characters in the data?