In this post, you’ll learn about the error message -206 column-name is not a column of an inserted table, updated table, or any table identified in a from clause in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-206 column-name is not a column of an inserted table, updated table, or any table identified in a from clause
Reason for the Error
This return code is used to report one of these errors:� *�� In the case of an 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 of 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.
Solution
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.
