DSXchange

hi,

i have a job from Oracle enterprsir stage to Dataset.the column QT from oracle has decimal dayatype. i am not changing the datatype of this column. In modify stage and in specification i just mentioned QT=QT and i want the output from modify to be QT with decimal datatype. the job is running successfully but showing errors like floating point decimal not fully supported adjusting the scale. I just want QT to be decimal in the output. I have given decimal(38,10) as precision and sclae in both input and ouput columns of modify stage for the column QT.

Can any one throw some light on this

Regards

Hi,

Do a search. I think this has been discussed before.

Iam not sure but from what I recall is, the specification should have the precision and scale like QT=QT[38,10].

HTH
--Rich

Why not just include QT in a KEEP specification?

dsdev_123 wrote:hi,
... I have given decimal(38,10) as precision and sclae in both input and ouput columns of modify stage for the column QT.

hi,
you should specify the conversion QT:decimal[38,10]=QT

== since you're not doing any conversion, this is a wrong answer == please ignore it == i cannot delete the post

dan

Hello Ray,

i did specify QT=QT in the specification. Do i need to specify KEEP QT in the specification.

thanks

No, one or the other (not both). Usually I prefer to KEEP unmodified columns - it seems less work.