How to convert integer data to float

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
harborboy76
Premium Member
Premium Member
Posts: 13
Joined: Wed Apr 07, 2010 11:50 pm

How to convert integer data to float

Post by harborboy76 »

I have an input data in integer format as below :

150000
10000
1099

Is there a function in DataStage to convert the above integer into :

1500.00
100.00
10.99

I am thinking about converting to CHAR , SUBSTRING and concatenate the "." But it doesn't seem very efficient.
N.K.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Not sure where the "float" part comes in as that's just decimal but how about dividing it by 100? And perhaps the DecimalToDecimal() function may come into the picture as well.
-craig

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