PM41499: DB2 ZOS - PROMPTMANY QUERY MACRO CAUSES IMPROPER SQL.

APAR status

• Closed as program error.

Error description

• DB2 zOS - promptmany query macro causes improper SQL.?This cause
  errors accessing DB2 zOS with decimal set to comma with multiple
  value (numbers) filter??This occurs only when SQL Type is set to
  'Native' or 'Pass-Through'.?With SQL type set to 'Cognos SQL'
  the required space is in the SQL sent to DB2.??For example:?A
  promptmany query macro fails because the value list separator
  (comma) cannot be identified because of missing space in the
  generated native SQL.??Sample SQL:?Wrong as currently
  generated:? SELECT p_key TABLE WHERE p_key in(1,2,3)
  ?Required:? SELECT p_key TABLE WHERE p_key in(1, 2, 3 )
  ??Errors being received are:
     ?RQP-DEF-0177 an error occured while performing operation
  'sqlPrepareWithOptions' statues='-9'.
   ?
     ?UDA-SQL-0107 A general exception has occurred during the
  operation "prepare".
             ??[IBM][CLI Driver][DB2] SQL0104N An unexpected token
  ",9" was found following "" (...) SQLSTATE=42601
  

Local fix

• Set SQL Type to 'Cognos'.
  

Problem summary

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

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

• Fixed component ID

  5724W12FM

Applicable component levels

• RA11 PSN

     UP