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

bpm.8570.cf2016.09.delta.repository.1of2
bpm.8570.cf2016.09.delta.repository.2of2
Downloading IBM Business Process Manager V8.5.7 Cumulative Fix 2016.09

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 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