JR52590: "XML" STAGE PRODUCES OUTPUT FOR DECIMAL NUMBER COLUMN VALUE = 0 IN EXPONENTIAL NOTATION INSTEAD OF EXPECTED DECIMAL NOTATION.

IBM InfoSphere Information Server, Version 11.3.1.2 (Fix Pack 2)

APAR status

• Closed as program error.

Error description

• Decimal number column [i.e. defined as (20,7)] of value = 0 is
  formatted on output of "XML" Stage in exponential notation :
  i.e. : 0E-7  instead of expected : 00000000000.0000000
  Other values are correctly formatted.
  This issue related with how's Java code convert the BigDecimal
  type to String. In our current XML pack, we use
  BigDecimal.toString() to convert the BigDecimal to String, this
  method returns  scientific notation if an exponent is needed.
  The other method BigDecimal.toPlainString() returns a string
  without an exponent field.
  

Local fix

• N/A
  

Problem summary

• Description:
  When input column type is decimal and output column type is
  string related, XML pack converts decimal to string in
  scientific notation if an exponent is needed. For example,
  decimal 00000000000.0000000 will be convert to 0E-7.
  

Problem conclusion

• Solution:
  Set environment XMLSTAGE_DECIMALTOPLAINSTRING=1, then XML pack
  will convert decimal to plain string. For example, decimal
  00000000000.0000000 will be converted to 0.0000000.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R912 PSY

     UP

• RB30 PSY

     UP

• RB31 PSY

     UP