Technote (troubleshooting)
Problem(Abstract)
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.
Symptom
When the input has a repeating item within a group defined as decimal numbers there are two ways to reference these numbers:
=NumberItem[5]:In1
or
=CHOOSE(NumberItem:In1,5)
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:
=CHOOSE(NumberItem:In1,Index)
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:
5,98
4,12
0,13
...will be converted to:
5,
4,
13,
...if using the CHOOSE() function to map these objects.
This does not affect any decimal numbers with the decimal delimiter defined as a dot.
Cause
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
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.