Conversion from character to Integer

prem84 · Post by **prem84** » Thu Sep 08, 2011 5:23 am

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?

premupdate · Post by **premupdate** » Thu Sep 08, 2011 5:38 am

A Trim on the particular field will work..

prem84 · Post by **prem84** » Thu Sep 08, 2011 5:56 am

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

ray.wurlod · Post by **ray.wurlod** » Thu Sep 08, 2011 4:50 pm

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.