Decimal value reading issue
Posted: Wed Oct 17, 2007 11:48 pm
Hi,
I have column-x as decimal(21) in the source and decimal(21,4) in the target. I am reading it from ASCII format sequential file and storing into ASCII sequential file. This is nullable column and inside a source actualvalue for this column is .01. However, I am assuming that since I am reading this column as decimal(21), it should truncate the 0.01 and only pass the value before decimal to output column. But it is addting
0.01 also in the output. Can anyone tell me why this is happening? Is there anyway to ignore zero if we mention decimal(m,0)? I don't want DS should read any value after decimal since there is no scale in the source data type.
Thanks in advance
-Amit
I have column-x as decimal(21) in the source and decimal(21,4) in the target. I am reading it from ASCII format sequential file and storing into ASCII sequential file. This is nullable column and inside a source actualvalue for this column is .01. However, I am assuming that since I am reading this column as decimal(21), it should truncate the 0.01 and only pass the value before decimal to output column. But it is addting
0.01 also in the output. Can anyone tell me why this is happening? Is there anyway to ignore zero if we mention decimal(m,0)? I don't want DS should read any value after decimal since there is no scale in the source data type.
Thanks in advance
-Amit