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

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

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