SAP Knowledge Base Article - Preview

1402831 - With DB2 on OS/390 mainframe, WebIntelligence report containing an InList condition with numeric values gives error: An unexpected token "," was found following ""

Symptom

  • When running a Web Intelligence query which contains a condition with an InList operator and a list of numeric values, the SQL generated is not being accepted by a DB2 database.
  • The values are being listed with just a comma between them in stead of a comma and a space and the database cannot interpret this.
  • In some circumstances if only two values are selected, the database reads the comma as a thousands separator and the message "No data returned for this query" is displayed.
  • Incorrect SQL:
    • SELECT *
      FROM table
      WHERE table.column IN (value,value,value)
  • Correct SQL:
    • SELECT *
      FROM table
      WHERE table.column IN (value, value, value)


Read more...

Product

SAP BusinessObjects Business Intelligence platform R2 ; SAP BusinessObjects Enterprise XI 3.1

Keywords

webi , KBA , BI-RA-WBI , Web Intelligence , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.