IBM Support

IT20802: ESQL CAST IGNORES DECIMAL SEPARATOR IN NON_ENGLISH LOCALES

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • In non-English locale, casting character as float or double may
    result in rounding numbers after the decimal mark. This is due
    to specific system settings, where decimal separator in the
    locale is not a decimal point, while in other system settings
    it is defined as decimal point.
    

Local fix

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    All users of IBM Integration Bus V9.0 and V10.0 with a
    non-English locale environment using custom ESQL which casts
    strings to double or float.
    
    
    Platforms affected:
    z/OS, MultiPlatform
    
    ****************************************************************
    PROBLEM DESCRIPTION:
    With a non-English locale, casting character strings as float or
    double may result in rounding numbers after the decimal symbol.
    This is due to specific system settings where the decimal
    separator in the locale is defined as a different symbol to the
    decimal point, a comma (',') for example, but in other system
    settings it is defined as a decimal point ('.').
    

Problem conclusion

  • The product now has an environment variable
    MQSI_IGNORE_DECIMAL_SEP_LOCALE that allow users to control which
    decimal separator is appropriate for their system. If this
    environment variable is set to any value, the locale's decimal
    symbol will be ignored and a decimal point ('.') will be used
    instead.
    
    ---------------------------------------------------------------
    The fix is targeted for delivery in the following PTFs:
    
    Version    Maintenance Level
    v10.0      10.0.0.10
    v9.0       9.0.0.9
    
    The latest available maintenance can be obtained from:
    http://www-01.ibm.com/support/docview.wss?rs=849&uid=swg27006041
    
    If the maintenance level is not yet available,information on
    its planned availability can be found on:
    http://www-1.ibm.com/support/docview.wss?rs=849&uid=swg27006308
    ---------------------------------------------------------------
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT20802

  • Reported component name

    INTEGRATION BUS

  • Reported component ID

    5724J0530

  • Reported release

    900

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-06-07

  • Closed date

    2017-08-31

  • Last modified date

    2017-08-31

  • 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

    INTEGRATION BUS

  • Fixed component ID

    5724J0530

Applicable component levels

  • R900 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSNQK6","label":"IBM Integration Bus"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.0","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
23 March 2020