SAP Knowledge Base Article - Preview

1184673 - Web Intelligence report does not retrieve data from an IBM DB2 CHAR(1) field


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.



SAP BusinessObjects Business Intelligence platform R2 ; SAP BusinessObjects Enterprise XI


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.