You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@openoffice.apache.org by bu...@apache.org on 2014/10/14 21:21:01 UTC

[Issue 58446] DB2 SQLCODE -243 on query against joined tables

https://issues.apache.org/ooo/show_bug.cgi?id=58446

DVC <dv...@arb.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |dvcroft@arb.com

--- Comment #11 from DVC <dv...@arb.com> ---
This is a problem on many queries. I ran into it trying to do column functions
like count(), avg(), max(), min(), etc.

The solution is to modify the connection string. You need to add the following
at the end
:cursorSensitivity=2;

In my case that means the Datasource URL becomes:
db2://andromeda:50000/ARBMAIN:cursorSensitivity=2;

-- 
You are receiving this mail because:
You are on the CC list for the issue.
You are the assignee for the issue.
You are watching all issue changes.