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)
- SELECT *
- Correct SQL:
- SELECT *
FROM table
WHERE table.column IN (value, value, value)
- SELECT *
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.