CODEWITHSUNDEEP
ibm-cloudcognosdashdb
Steve L
Steve L

Reputation: 1

Cognos Analytics support for column organized table

Are there any compatibility issues with Congos Analytics and column-organized tables?

I am getting the following error message from the Framework manager when I try to view data in a DashDB instance.....

Data source adapter error: com.ibm.db2.jcc.am.SqlSyntaxErrorException: The operation failed because the operation is not supported with the type of the specified table. Specified table: "GOSALES.COUNTRY". Table type: "ORGANIZE BY COLUMN". Operation: "WITH RS".. SQLCODE=-1667, SQLSTATE=42858, DRIVER=3.66.46 - when processing query: SELECT DISTINCT "COUNTRY"."COUNTRY_CODE" AS "COUNTRY_CODE" FROM "GOSALES"."COUNTRY" "COUNTRY" FOR FETCH ONLY.

Thanks

Upvotes: 0

Views: 369

Answers (1)

data_henrik
data_henrik

Reputation: 17118

The reason for the error is the RS isolation. Queries using the RR or RS isolation level are not supported with column-organized tables and the WITH RS is a non-supported clause in that context. So what you should do is to make sure the isolation level is set to READ COMMITTED for the database connection.

Cognos Analytics supports dashDB as well as DB2 with BLU Acceleration.

Upvotes: 0

Related Questions