WebSphere® Transformation Extender has the potential for changes of numeric data values when using the CHOOSE() function on decimal numbers with a comma as decimal delimiter.
When the input has a repeating item within a group defined as decimal numbers there are two ways to reference these numbers:
Both will get the 5th iteration of the repeating object, though CHOOSE() is preferred, because the second argument can be a reference itself, and does not need to be hardcoded in the rule:
However, if NumberItem is a decimal, and the decimal delimiter is a comma, some of the data will be lost and/or changed. For example, the following input:
...will be converted to:
...if using the CHOOSE() function to map these objects.
This does not affect any decimal numbers with the decimal delimiter defined as a dot.
This has been identified as a product defect under APAR PM77034
Diagnosing the problem
Decimal numbers losing the non-whole part.
Resolving the problem
Obtain and apply APAR PM77034
Ascential DataStage TX