IBM Support

JR56462: DDL CREATED FOR IBM DB2 FOR z/OS MISSING A BLANK AFTER THE COMMA WHEN COMMA IS USED AS A DECIMAL POINT

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The problem with the DECIMAL=COMMA setting in IBM DB2 for z/OS
    impacts several SQL scripts in IBM Business Process Manager
    (BPM).
    
    DB2 for z/OS has a setting to accommodate the practice common to
    many Eastern European countries of using a period (.) to
    separate groups of integers in large numbers; the comma (,) is
    used to represent the decimal (.). For example, the number
    12,345,678.90 might appear as 12.345.678,90.
    
    DB2 subsystems with this setting active sometimes encounter
    problems with SQL when numeric parameters are concerned because
    in SQL the comma is also used as a parameter separator. The
    string "1,2" in systems that  do not use decimal=comma is
    interpreted as two separate parameters: 1 and 2. In a
    decimal=comma system, this string is interpreted as one
    parameter: 1,2 (or 1.2).
    
    A comma that has no space following it is interpreted as a
    decimal separator in decimal=comma system and attempts to run
    the SQL script could result in various SQL errors, for example
    in the following error:
    
    DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601,
    SQLERRMC=(;FIELDPROC CHECK
    GENERATED IMPLICITLY INLINE CONSTRAINT PRIMARY, DRIVER=4.18.74
    
    PRODUCTS AFFECTED
    IBM BPM Advanced
    IBM BPM Standard
    IBM BPM Express
    

Local fix

  • Add a space after each comma character (eq modify DECIMAL(12,0)
    to DECIMAL(12, 0))
    

Problem summary

  • In IBM BPM SQL scripts for DB2 for z/OS, the comma used to
    separate values is misinterpreted as a decimal point when the
    DECIMAL=COMMA setting is activated.
    

Problem conclusion

  • A fix will be included in IBM BPM V8.5.7 cumulative fix 2016.09
    that inserts a blank after commas that are intended as a
    separator between values. When the comma is being used as a
    parameter separator, it is always followed by a space.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR56462

  • Reported component name

    BPM ADVANCED

  • Reported component ID

    5725C9400

  • Reported release

    857

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-08-10

  • Closed date

    2016-08-26

  • Last modified date

    2016-08-26

  • 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

    BPM ADVANCED

  • Fixed component ID

    5725C9400

Applicable component levels

  • R857 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"857","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
26 August 2016