Converting decimals

[mydsworld]

I want to convert a decimal field from Length,Precision 8,4 to 11,9.

DecimalToDecimal function converts the source field to target with all zeroes.

Please advise.

[sud]

How about just a change in the scale and precision ... since it is a change from smaller scale and precision to bigger the default conversion should be just fine. Have you tried that?

[mydsworld]

I tried that since it is length,precision (8,4) to (11,9), am getting target values like this :

??.000000000

which on trying to insert into a table fails.

So, then I tried something like DecimalToDecimal(<Input Decimal Field>)

Then I am getting all values in zero like

00.000000000

[sud]

If the data is finally landing into the database, just leave the datatype as the original one. Another approach could be, change the precision and scale in the source itself.