IIS-CONN-DB2-00477E One or more key columns are of a LOB data type. LOB data types cannot be used as key columns when Generate SQL is set to Yes and the generated statement will have a WHERE clause, such as when performing sparse lookups or the Write mode is Update, Insert then update, Update then insert, or Delete
Explanation
One or more key columns are of a LOB data type. You cannot use LOB data types as key columns when the Generate SQL property is set to Yes and the generated SQL statement contains a WHERE clause, such as SELECT, INSERT, UPDATE, or DELETE statements.One or more key columns are of a LOB data type. Typically this error occurs when the Db2 connector generates an SQL statement that contains a WHERE clause, such as SELECT, INSERT, UPDATE, or DELETE statements and all key columns are included in the clause. LOB data types cannot be included in the WHERE clause.
User response
Do one of the following actions:- Do not designate LOB columns as key columns.
- Set the Usage > Generate SQL property to No and manually enter your SQL statement.