DSXchange

Hello,
Iam Trying to Convert a Decimal 13,5 Field to Decimal 9,5 in Data stage 7.5 Transformer stage. I have used DecimalToDecimal Function , Converted to String then back to decimal etc ., but the output is coming with all zero values in it . Also tried using Modify Stage . No +ve result

Some one - help me out in acheiving this

Are all results always zeroes or do some work and some do not? Post your actual syntax, that and confirm for us that the values in your 13,5 will actually fit in a 9,5 decimal.

And seriously, "+ve"? It was too much trouble to spell out the word "positive"?