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

Barb_Fill21 — Wed, 19 Feb 2025 08:13:41 GMT

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

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

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

Resolution

Internal Investigation ID(s)

Environment