PM85469: MISSING SPACE IN IN-FILTER ENUMERATION AGAINST DB2 Z/OS FOR DQM

APAR status

• Closed as program error.

Error description

• When zParm DECIMAL=COMMA is set on DB2 z/OS, any enumeration
  requires a space behind the delimiter. The space is not
  generated in native SQL, when parameterized filters are used, or
  a in filter is set on a prompt query.??The following error
  message is displayed: com.ibm.db2.jcc.am.
  SqlSyntaxErrorException: ILLEGAL SYMBOL ",48". SOME SYMBOLS THAT
  MIGHT BE LEGAL ARE: AT MICROSECONDS MICROSECOND SECONDS SECOND
  MINUTES MINUTE HOURS. SQLCODE=-104, SQLSTATE=42601,
  DRIVER=x.xx.xx??The SQL is correctly generated when Select All
  is used in a prompt, or when the values are selected within
  Report Studio Filter window.
  

Local fix

• Instead of an in-filter, use a prompt macro. For example: [Eleme
  nt] in (#promptmany('Parametername','numeric','','',',','')#)
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.2 Refresh     *
  * Pack 1                                                       *
  * or IBM Cognos Business Intelligence 10.2 Fix Pack 2          *
  ****************************************************************
  

Problem conclusion

• Code Fix
  

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

  COG REPORT STUD

• Fixed component ID

  5724W12RS

Applicable component levels

• RA20 PSN

     UP