IC88644: Inconsistent removal of trailing and leading zeros when converting number literals to string in NUMBER datatype mode

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • This APAR is only applicable to databases created with NUMBER
    data type compatibility feature turned on. It contains two parts
    
    Part 1:
    The VARCHAR function applied to a number literal does not remove
    the trailing zeros. This APAR provides a fix to remove the
    trailing zeros from the input number literal to be
    consistent with the CHAR function. For example:
    
    CHAR(0123.450)
    
    returns
    
    123.45
    
    By applying this fix,
    
    VARCHAR(0123.450)
    
    will also return
    
    123.45
    
    
    Part 2:
    The CAST specification with a number literal as the operand and
    cast to CHAR, VARCHAR, GRAPHIC, VARGRAPHIC does not conform to
    the semantic of the equivalent function forms, such as
    CHAR(123.450), VARCHAR(123.450). With the fix provided by this
    APAR, all castings using the CAST keyword to CHAR, VARCHAR,
    GRAPHIC, VARGRAPHIC will return the string representation of the
    number literal with all the leading and trailing zeros removed.
    For example,
    
    CAST(123.450 as VARCHAR(20))
    
    will return the string "123.45".
    
    Note:
    The database with the NUMBER data type enabled will have the
    number_compat database configuration parameter set to ON. The
    NUMBER data type feature is enabled when setting the fifth bit
    position of the DB2_COMPATIBILITY_VECTOR (0x10) prior to the
    creation of the database.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 version 10.0.1.2.                             *
    ****************************************************************
    

Problem conclusion

  • Upgrade to DB2 version 10.0.1.2.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC88644

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-28

  • Closed date

    2013-01-07

  • Last modified date

    2013-01-07

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

    IC86177

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RA10 PSN

       UP

  • RA10 PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

10.1

Reference #:

IC88644

Modified date:

2013-01-07

Translate my page

Machine Translation

Content navigation