Search found 2 matches

by sanjay.v
Mon Jul 30, 2007 6:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Rounding Decimal in Transformer
Replies: 5
Views: 3078

First try using DecimalToDecimal function in transformer... and check for required output... If this doesn't work, try this first convert the decimal field into string and use the string function Left() to get the first seven digits.Once you get this, convert this result back to Decimal for target m...
by sanjay.v
Mon Jul 30, 2007 5:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Duplicate insert warning in the Database
Replies: 2
Views: 1392

i think your write method is upsert and upsert mode is insert only..and you are trying to insert a duplicate record into the table... check whether the option - output reject records is set to true...and try capturing the rejects...