DB2 Error Code – -503 a column cannot be updated because it is not identified in the update clause of the select statement of the cursor

In this post, you’ll learn about the error message -503 a column cannot be updated because it is not identified in the update clause of the select statement of the cursor in the IBM DB2 database , the reason why it occurs along with the solution to fix it

IBM DB2 Error Message

-503 a column cannot be updated because it is not identified in the update clause of the select statement of the cursor

Reason for the Error

The application program attempted to update (using a cursor)� a value in a column of the object table that was not identified in the FOR� UPDATE clause in the cursor declaration.� Any column that is to be updated must be identified in the FOR UPDATE� clause of the cursor declaration.

Solution

Correct the application program.� If the column is� to be updated, its name must be added to the FOR UPDATE clause of the� cursor declaration.