Hi all,
Got some problems with OCI decimals.
My job is OCI => dataset
My select is basic and do not have any conditions and i just take three key columns not nullable.
I import metadata and let DS choose columns type.
First is decimal 6, second is varchar and last one decimal 11.
In the DB source, i have 3273 in the 3rd column and in output, i found 32731.
I don't have any warnings neither aborts.
If i do a to_char in the select it runs ok.
Don't understand.
Decimal problem with OCI
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Importing table definitions through OCI is known to be inaccurate for decimal data type. Even IBM recommends that you import Oracle table definitions using Orchestrate (the orchdbutil utility).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: Decimal problem with OCI
please could you provide more values where you are facing problem, just to analyze the data, may be something related to trunc or rounding of values, or may be something as suggested by ray.