DSXchange

Hi,
I have a peculiar issue. In datastage 7.1 when I used source as char(4) and value (26 two leading spaces) and convert to integer (without any function) it goes through fine but in 8.1 it is converted to zero. Since we need to change for lot of jobs is there any environmental variable settings which can be changed?

A Trim on the particular field will work..

But the number of jobs is more and we are not sure how much more is impacted Is there a way to find it or will a change to any environmental variable will solve it

I don't think there's any "automatic" mechanism here. The granularity is too fine to use Find. Others will recommend search and replace in a DSX file, but you would need to be so, so careful not to change anything incorrectly.