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:
Parent topic: DB2 connector messages