Hello,
We have found a bug in our AIX-DataStage 7.5.2 software. The usage of the ODBC Enterprise stage with Decimal datatypes and with Write Method = Upsert causes ALL decimal datatypes to become corrupt. That is, all decimal(scale, precision) datatypes are corrupted.
What happens when selecting Write Method = Upsert is that the stage strips of the rightmost digit (the worst case) of the scale. It is also strips off the two rightmost digits of the precision. Anyways, IBM has created a patch for this bug. E129600.
Hopefully this hasn't caused anyone else data problems.
DataStage 7.5.2 ODBC Enterprise Stage Decimal Corruption Bug
Moderators: chulett, rschirm, roy
-
Ultramundane
- Participant
- Posts: 407
- Joined: Mon Jun 27, 2005 8:54 am
- Location: Walker, Michigan
- Contact:
-
Ultramundane
- Participant
- Posts: 407
- Joined: Mon Jun 27, 2005 8:54 am
- Location: Walker, Michigan
- Contact:
Not sure, but I knew that I better mention that we ran into this on specifically with 7.5.2 and AIX. I think it should be easy for someone to validate. What was remarkable was that all other stages seemed to work correctly. Including, the DRDMS Stage with ODBC Data Source.chulett wrote:Is this specific to AIX?
