data type

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
sangi1981
Participant
Posts: 99
Joined: Fri Jun 13, 2008 8:10 am

data type

Post by sangi1981 »

Hi all,
I have to treat with financial data, decimal field with many digits after comma.
What is better data type I can use for among float, double(dfloat) and decimal?
I don't understand difference between float-dfloat and decimal.
Thanks in advance.
Etler21
Participant
Posts: 52
Joined: Mon Mar 08, 2010 5:51 am

Post by Etler21 »

Double will round off your data,I find Decimal with large precision works better.
Post Reply