IIS-CONN-DB2-00947E To generate SQL statements, one or more key columns must be specified.
Explanation 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.