+206 column-name IS NOT A COLUMN OF AN INSERTED TABLE, UPDATED TABLE, MERGED TABLE, OR ANY TABLE IDENTIFIED IN A FROM CLAUSE

Explanation

This return code is used to report one of these errors:
  • In the case of an INSERT or UPDATE statement, or SELECT FROM INSERT or UPDATE statement, the specified column is not a column of the table or view that was specified as the object of the insert or update.
  • In the case a SELECT or DELETE statement, the specified column is not a column of any of the tables or views identified in a FROM clause in the statement.
  • There is a correlated reference in GROUP BY.
  • There is an unresolved qualified reference in HAVING.
  • In the case of a MERGE statement or SELECT from MERGE statement, the specified column is not a column in the target-table. Also, it is not a column specified in the include-columns clause.

System action

A valid plan or package will be created if no errors are detected. The statement is bound dynamically on each execution of the statement.

Programmer response

For better performance, rebind the plan or package after correcting the statement. To correct the statement, verify that the column and table names are specified correctly in the SQL statement. In the case of a SELECT statement, check to be sure that all of the required tables were named in the FROM clause.

SQLSTATE

01533