Page 1 of 1

invalid decimal fields are being read as "000.00",

Posted: Sun Jan 18, 2009 12:16 am
by 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???

Posted: Sun Jan 18, 2009 12:19 am
by 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'