SQLLDR truncating decimal places beyond a scale of 10
Posted: Wed May 21, 2008 10:10 am
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.
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.