Data getting trucated in DB2 Connector
Posted: 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.
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.