I am connecting to DashDB thru an ODBC connection in OpenOfficeCalc. I can correctly display tables.
However, I am not able to display any data, because OpenOffice appends FOR UPDATE clause to SELECT statement, making DashDB send back SQL1667, clause not supported for ORGANIZED BY COLUMN tables.
I don't see any option to remove this in OpenOffice, is there a way to tell DashDB to ignore such clauses ?