JR48193: ORACLE CONNECTOR IS SILENTLY TRUNCATING DECIMAL VALUES IN 9.1

InfoSphere Information Server, Version 11.3 for Microsoft Windows
InfoSphere Information Server, Version 11.3 for AIX
InfoSphere Information Server, Version 11.3 for Linux
IBM InfoSphere Information Server Enterprise Edition V11.3 for Windows

APAR status

• Closed as program error.

Error description

• Oracle Connector is silently truncating decimal values in 9.1
  when design schema does not match the underlying Oracle schema.
  For example, when extracting a NUMBER(24,12) to a DECIMAL column
  with precision 24 and scale 10, the two least significant
  fractional digits will be dropped.
  

Local fix

• Use correct schema
  

Problem summary

• Oracle Connector silently truncates decimal values starting in
  9.1 when the design schema does not match the underlying Oracle
  schema. Prior to 9.1 the behavior was that the value was rounded
  to the nearest value rather than truncating.
  

Problem conclusion

• The switch to the Big Buffer API in 9.1 meant a switch to the
  internal data structure used for decimal values. Prior to 9.1
  the connector would retrieve these values into a string buffer
  large enough for the maximum precision and scale of a decimal
  value. That value would then be parsed by the parallel engine,
  which would round the value to the design schema. Starting in
  9.1 the connector retrieves the value using packed decimal
  format. The Oracle OCI API itself is doing the truncation.
  
  The fix is to provide a new warning at job startup if the
  possibility exists for this situation. Create and set
  environment variable CC_ORA_DECIMAL_MISMATCH_ACTION to WARN to
  enable this warning.
  

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

• R910 PSY

     UP