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.
Search found 4 matches
- Wed Apr 15, 2009 12:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Experiencing issue with ODBC - decimal truncated
- Replies: 6
- Views: 2868
- Wed Apr 15, 2009 7:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Experiencing issue with ODBC - decimal truncated
- Replies: 6
- Views: 2868
Re: Experiencing issue with ODBC - decimal truncated
I'm wondering if this is a bug in the tool. What is the best way to identify if it is a bug ?
- Tue Apr 14, 2009 12:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Experiencing issue with ODBC - decimal truncated
- Replies: 6
- Views: 2868
Re: Experiencing issue with ODBC - decimal truncated
decimal 11,2
- Tue Apr 14, 2009 7:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Experiencing issue with ODBC - decimal truncated
- Replies: 6
- Views: 2868
Experiencing issue with ODBC - decimal truncated
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 cha...