how to convert 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
marpadga18
Premium Member
Premium Member
Posts: 96
Joined: Fri Aug 20, 2010 8:51 am

how to convert to decimal

Post by marpadga18 »

hi I facing some problem to find the logic to implement the logic for below requirement can any one share there ideas??

Source Sql server DB (query)
Column Name
6200
6200
130000
130000

the data is like this in source I need the output as below
Target (sequential file)
Column Name
62.00
62.00
1300.00
1300.00
for every record it should be .00
how to get this output can any one share some logic..
Thanks,
M
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Divide by 100.
-craig

"You can never have too many knives" -- Logan Nine Fingers
marpadga18
Premium Member
Premium Member
Posts: 96
Joined: Fri Aug 20, 2010 8:51 am

Post by marpadga18 »

chulett wrote:Divide by 100.
I got it but it is giving zeros in front of the data
001300.00
000062.00
I tried to suppress the zero but it is removing zeros at the end also as below

1300.
62.

is there any way how to remove zero infront
Thanks,
M
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

If your target datatype is decimal you'll get all of those zeros. If you don't want them, you'll need to convert it back to a string using the appropriate mask for your desired target format.
-craig

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