SQLLDR truncating decimal places beyond a scale of 10

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Bill_G
Premium Member
Premium Member
Posts: 74
Joined: Thu Oct 20, 2005 9:34 am

SQLLDR truncating decimal places beyond a scale of 10

Post by Bill_G »

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.
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Are the correct number of decimals appearing in the DAT file?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”