I am using the OCI stage with the Load option in DS 7.5.1a on Linux - writing to an Oracle 10g database.
I have values with more than 10 decimal places. I've tried using several datatypes: Decimal, Double and text but still the digits are being lost with the Load option I've converted these numbers to text in hopes of avoiding the rounding issue. However when I attempt to load these values in DS with the Load option that uses SQLLDR the decimals after the 10th are lost. If however the Upsert option is used the decimals are all preserved.
Is there a parameter I haven't considered?
Thanks.
SQLLDR truncating decimal places beyond a scale of 10
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: