More problems with Pesky Floats

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

Andet
Charter Member
Charter Member
Posts: 63
Joined: Mon Nov 01, 2004 9:40 am
Location: Clayton, MO

Post by Andet »

ray.wurlod wrote:Is there not an optional "Decimal Type" property where you can set precision and scale?
I've worked at banks for most of my career. From a Savings Bank to the NY Fed., all use 'decimal' types for dollars and cents, and all calculations are done BCD. It's probably one of the greatest reasons that banks are still using COBOL. It doesn't matter what you do with rounding or whatever, when you're calculating interest out to 10-11 decimal places(compounding factors), there's no way a conversion to and from float or doubles will give you the correct answer 100% of the time.
And that's the biggest problem...unless a bank want's to end up in court, the calculations have to be right 100% of the time.

Ande
Post Reply