DB2 Error Code – -205 column-name is not a column of table table-name

In this post, you’ll learn about the error message -205 column-name is not a column of table table-name in the IBM DB2 database , the reason why it occurs along with the solution to fix it

IBM DB2 Error Message

-205 column-name is not a column of table table-name

Reason for the Error

No column with the specified ‘column-name’ occurs in the table or view ‘table-name’.

Solution

Verify that the column and table names are specified correctly (including any required qualifiers) in the SQL statement.