Qlik Replicate and IBM DB2 iSeries: Numeric decimal point not in correct place with Qlik Replicate 2024.5

[Barb_Fill21]

When using Qlik Replicate 2024.5 Initial Release, SP01, and SP02, reading transactions from DB2 iSeries receivers and using ODBC driver 7.1.25 (aka iAccess13.64.25 and older), the decimal point in a Numeric/decimal fields in the target environment was in the wrong place. 

Example:

DB2 iSeries
     SOURCE Column:   ColA  decimal (9, 1) NOT NULL  
            Source Data  shows  20.0
            Target Data   shows 200.0 

Resolution

This is a known issue in Qlik Replicate starting with the version 2024.5 initial release. Qlik has supplied a fix in Qlik Replicate 2024.5 SP03.

Internal Investigation ID(s)

Product Defect ID: RECOB-8827 

Environment

• Replicate 2024.5 Initial Release
• Replicate 2024.5 SP01
• Replicate 2024.5 SP02