IIS-CONN-DB2-00947E To generate SQL statements, one or more key columns must be specified.


No key columns are available that the connector can use to generate the SQL statement. Key columns might not be available because they were dropped from the link. Key columns can be dropped from the link when no match for the columns exists in the target table or the temporary work table or when the data type of the columns did not match.

User response

Make sure that the columns are in the target and temporary work table and that the data types for the columns match. Alternatively, select different key columns.