Hi,
I have a DB2 table, one field in this table is double type. When I dumped this table into file through datastage, it seems it loses precision. For example: a value '3.29999995231628' becomes '3.299999952', even though the column definition is specified as double.
Has anyone evern experienced same situation? What should I do?
Thanks,
Carol
DB2 precision problem
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 85
- Joined: Fri Jun 04, 2004 2:30 am
- Location: Melbourne, Australia
- Contact:
-
- Participant
- Posts: 85
- Joined: Fri Jun 04, 2004 2:30 am
- Location: Melbourne, Australia
- Contact:
When viewing the value in the DB2 client the value is: '3.29999995231628'
and then when viewing through datastage it becomes '3.299999952' ?
Try 'Double' as the SQL Type or 'Float' with a Precision value of 14 or greater if required (I believe you can go up to a precision of 308).
and then when viewing through datastage it becomes '3.299999952' ?
Try 'Double' as the SQL Type or 'Float' with a Precision value of 14 or greater if required (I believe you can go up to a precision of 308).
Cheers,
Dave Nemirovsky
Dave Nemirovsky