Conversion error

[nveejas]

My source is a fixed width file. In that i have a field with value as 000012345.00 in source. In the target it is decimal. so when i try to convert it to decimal with stringToDecimal function i'm getting the following warning and also in target the value is convrted as 000000.00,

APT_CombinedOperatorController,0:Conversion error calling conversion routine decimal_from_string data may have been lost

Please give me some suggestions inorder to get correct value in the output without any warnings.
Note: Source daatype- char(12)
Target datatype - decimal(9,2)

[SURA]

Hence the source is char it may have space. Change the data type as VC as well as use ' ','A' in the TRIM function.

[pandeesh]

But i believe, there may not be any space, since his data is exactly 12 character long 000012345.00

[ray.wurlod]

Given your data types this is a spurious error ("they" are being over-cautious). Use a message handler to demote it.

[nveejas]

Hi Ray,

I can demote it but the value populated in targer is not correct. It is converted to 0000000.00 (total 9 zeros) and also as pandeesh said the lenght is exactly 12 charactes.

[qt_ky]

You're losing data because 000012345.00 would require decimal(11,2) rather than 9,2.

[nveejas]

Hi Eric,

you are right..
Issue is solved..