JR27828: TRAILING ZEROS ARE BEING TRIMMED BY THE DB2 .NET PROVIDER WHEN A DECIMAL VALUE IS FETCHED

DB2 Version 9.1 Fix Pack 7  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 5   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

APAR status

• Closed as program error.

Error description

• When decimal values are fetched by the .NET application, DB2
  .NET provider trims off the trailing zeros before
  returning the values. It shouldn't be doing that.  This started
  occurring in DB2 v9.1 GA.  The fix will be provided in v9.1 FP5
  and will also be included in v9.5 FP1.
  
  Example:
  You retrieved a decimal column from a table, 29.02, via the
  CLP.  When you use the .Net driver to retrieve the same you only
  get 29 (the scale is missing).
  

Local fix

Problem summary

• TRAILING ZEROS ARE BEING TRIMMED BY THE DB2 .NET PROVIDER WHEN A
  DECIMAL VALUE IS FETCHED
  

Problem conclusion

• APAR first fixed in 9.1 FP5
  

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:

  JR28845

Fix information

• Fixed component name

  DB2 UDB ESE WIN

• Fixed component ID

  5765F4101

Applicable component levels

• R910 PSY

     UP