IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    JR27828

  • Reported component name

    DB2 UDB ESE WIN

  • Reported component ID

    5765F4101

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2007-11-13

  • Closed date

    2008-06-23

  • Last modified date

    2008-06-23

  • 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

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910"}]

Document Information

Modified date:
07 October 2021