invalid decimal fields are being read as "000.00",

[zulfi123786]

hi,
i am reading decimal fields from sequential file, if the record contains invalid decimals the record is not getting dropped instead DS is reading the value as all 0's. Is this the default behaviour of DS or is there any setting that needs to be done to make datastage do this???

[miwinter]

Yes it's the default set on error for the datatype. You can override it in the extended metadata with decimal type property 'Default'