Symptom
In BusinessObjects Enterprise XI Release 2 running on IBM AIX, a Web Intelligence report does not retrieve data from a CHAR(1) field in a IBM DB2 database. A blank column is returned.
If the column definition is changed to CHAR(2), the report retrieves data successfully. Also, if custom SQL is used with "CHAR_ONE_FIELD ||" in the Select statement, the report retrieves the data successfully.
Read more...
Product
SAP BusinessObjects Business Intelligence platform R2 ; SAP BusinessObjects Enterprise XI
Keywords
webi intelligence report, DB2, DB2CODEPAGE , 1727766 , KBA , BI-BIP , Business intelligence platform , How To
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.