Type Conversion - Decimal To Decimal

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
bicap
Premium Member
Premium Member
Posts: 95
Joined: Mon May 03, 2010 10:22 pm
Location: India
Contact:

Type Conversion - Decimal To Decimal

Post by bicap »

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
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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"? :?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply