IIS-CONN-DB2-00416E There are one or more columns with the name Column name in the result set.

Explanation

One or more columns with the name Column name exist in the result set.
One or more columns with the specified name exist in the result set. Typically this error occurs for one of the following reasons:
  • SQL statement contains expressions that produce columns in the result set.
  • Db2 assigns a numeric name to the columns that are produced by expressions in the SQL statement. After concatenating the value in the Usage > Prefix for expression columns property with the numeric name, The connector detects a conflict with one of the columns in the design schema.

User response

Do one of the following actions:
  • Change the name of the conflicting column in the design schema.
  • Remove the expressions from the SQL statement.