Experiencing issue with ODBC - decimal truncated

[stk]

We recently migrated from Datastage version 7.5.2 to 7.5.3 and started experiencing this issue with ODBC stage for ORacle database. The column with decimal digits is dropping/truncating. We are using upsert write method. This very same ETL was working fine earlier w/ version 7.5.2.

The moment we change the write method to "write" the decimal digits are not being truncated. We are unable to figure why the ETL is behaving fine with write and not with upsert.

Pls help out!

[dsuser_cai]

What is the data type you are using there, is it decimal or double.

[stk]

decimal 11,2

[stk]

I'm wondering if this is a bug in the tool. What is the best way to identify if it is a bug ?

[dsuser_cai]

Could you try double, because we use double data type (dont specify the length, just leave it blank). let me know if still problem exist.

[stk]

Yes. That worked. Thanks!

However my orginal question about why this worked in 7.5.2 and is not working in 7.5.3 is unanswered. So far, we have 2 solutions to get this to work:
- change write method from upsert to Write
- change column from decimal to double.

[philolaos]

Yes. That worked. Thanks!

However my orginal question about why this worked in 7.5.2 and is not working in 7.5.3 is unanswered. So far, we have 2 solutions to get this to work:
- change write method from upsert to Write
- change column from decimal to double.

We have a problem that look a lot like yours; decimal truncated in an upsert through the Oracle stage on a 7.5.3 box.

Did you finally found an exlanation?