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!
Experiencing issue with ODBC - decimal truncated
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 151
- Joined: Fri Feb 13, 2009 4:19 pm
Re: Experiencing issue with ODBC - decimal truncated
What is the data type you are using there, is it decimal or double.
Thanks
Karthick
Karthick
Re: Experiencing issue with ODBC - decimal truncated
decimal 11,2
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 ?
-
- Premium Member
- Posts: 151
- Joined: Fri Feb 13, 2009 4:19 pm
Re: Experiencing issue with ODBC - decimal truncated
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.
Thanks
Karthick
Karthick
Re: Experiencing issue with ODBC - decimal truncated
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.
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.
-
- Premium Member
- Posts: 11
- Joined: Wed Sep 10, 2003 7:38 am
- Location: Montreal, Canada
- Contact:
Re: Experiencing issue with ODBC - decimal truncated
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.stk wrote: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.
Did you finally found an exlanation?
Stéphane Poirier
SHP Consult SA
SHP Consult SA