7.5.1.A to 7.5.3 upgrade issue with decimal columns in UDB
Posted: Fri Jul 18, 2008 6:58 am
We have just upgraded from 7.5.1.A to 7.5.3 and are seeing some strange issues with decimal values.
The target database is UDB on AIX and it is loaded using an ODBC stage.
The first issue is when trying to insert decimal(8,0) values.
The target column is defined as decimal(8,0) in the database the transformer and the ODBC stage however the value being loaded has the rightmost digit truncated (in this case the actual value is only 6 digits)
If the column is defined as an integer in the transformer and the ODBC stage then the correct value is loaded
The second issue is slightly different although I suspect related.
In this case we are attempting to update a UDB table but one of four key columns is defined as decimal(8,0) throughout the job and the join is failing so no updates occur. If this column is redefined in the job to integer then the join is working and the updates take place.
Both of these jobs were fine before the upgrade so I am at a loss to explain it.
Thanks in advance for any suggestions.
The target database is UDB on AIX and it is loaded using an ODBC stage.
The first issue is when trying to insert decimal(8,0) values.
The target column is defined as decimal(8,0) in the database the transformer and the ODBC stage however the value being loaded has the rightmost digit truncated (in this case the actual value is only 6 digits)
If the column is defined as an integer in the transformer and the ODBC stage then the correct value is loaded
The second issue is slightly different although I suspect related.
In this case we are attempting to update a UDB table but one of four key columns is defined as decimal(8,0) throughout the job and the join is failing so no updates occur. If this column is redefined in the job to integer then the join is working and the updates take place.
Both of these jobs were fine before the upgrade so I am at a loss to explain it.
Thanks in advance for any suggestions.