IIS-CONN-GP-01075E   To generate an UPDATE statement, one or more non-key columns must be specified.


No update columns are available that the connector can use to generate the SQL statement. Update columns might not be available because they were dropped from the link. Update columns can be dropped from the link when no match for the columns exists in the target table or the temporary table or when the data type of the columns do not match. This message is not shown if all available columns are selected as keys.

User response

Complete one of the following tasks:
  • Ensure that the columns are in the target table and temporary table and that the data types for the columns match.
  • Select different update columns.