Division

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
dstest
Participant
Posts: 66
Joined: Sun Aug 19, 2007 10:52 pm

Division

Post by dstest »

Hi,

I want to divide 364/30 and i am expecting valu 12.13,But when i did in a transformer by putting data type as decimal i am getting 12.00.What i need to do to get the exact value instead of zeros.

Thanks
narasimha
Charter Member
Charter Member
Posts: 1236
Joined: Fri Oct 22, 2004 8:59 am
Location: Staten Island, NY

Post by narasimha »

For starters - check your Precision and Scale values.
Narasimha Kade

Finding answers is simple, all you need to do is come up with the correct questions.
Krazykoolrohit
Charter Member
Charter Member
Posts: 560
Joined: Wed Jul 13, 2005 5:36 am
Location: Ohio

Post by Krazykoolrohit »

Can anyone please explain why is this needed?

I got the same issue and this post helped me but i am still wondering why i had to convert it to float.
Post Reply