Hello I have made a connection to my DB2 Database from LibreOffice Base. I can query simple tables. When I try to access and Views or use any table function I always get :
DB2 SQL Error: SQLCODE=-243 SQLSTATE=36001, SQLERRMC=SQL_CURSH200C2,DRIVER=3.66.46
In DB2 the error describes as follows :
SQL0243N
SENSITIVE cursor cursor-name cannot be defined for the specified SELECT statement.
Explanation
Cursor cursor-name is defined as SENSITIVE, but the content of the SELECT statement requires DB2 to build a temporary result table of the cursor, and DB2 cannot guarantee that changes made outside this cursor will be visible. This situation occurs when the content of the query makes the result table read-only. For example, if the query includes a join, the result table is read-only. In these cases, the cursor must be defined as INSENSITIVE or ASENSITIVE.
The statement cannot be processed.
User response
Either change the content of the query to yield a result table that is not read-only, or change the type of the cursor to INSENSITIVE or ASENSITIVE.
sqlcode: -243
sqlstate: 36001
Can you help me here ? What am I doing wrong ? Without that functionality The JDBC connection is useless