IBM Support

Decimal information lost when using the CHOOSE() function

Technote (troubleshooting)


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

Product Alias/Synonym

Ascential DataStage TX

Document information

More support for: Transformation Extender
Core Engine

Software version: 8.2,,,,,,,, 8.3,,,,,,, 8.4,,,,

Operating system(s): AIX, HP-UX, Linux, Platform Independent, Solaris, Windows, z/OS

Reference #: 1618007

Modified date: 06 March 2015