Oracle Error

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
Abhinav
Premium Member
Premium Member
Posts: 65
Joined: Tue Jun 29, 2004 10:26 am
Location: California

Oracle Error

Post by Abhinav »

Oracle_Enterprise_0: Column YEAR_NO floating point decimal not fully supported. Adjusting scale.

Any soln for the above warning would be appreciated.

I get this warning while reading and writing to a oracle table.

The data types what i specify in my column definitions doesnt make any chab=nge as the warning remains the same.

Do i need to change any environment settings in px so that my data type matches the internal type conversion.


Thanks

Abhi
ririr
Participant
Posts: 84
Joined: Sun Apr 04, 2004 8:59 pm

Post by ririr »

I think you have the column defined with Lengh and scale on the source side. Modify the target column's length and scale to be in sync with the source. It should work..
Post Reply