In this post, you’ll learn about the error message -121 the column name is identified more than once in the insert or update statement in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-121 the column name is identified more than once in the insert or update statement
Reason for the Error
The same column ‘name’ is specified more than once, either in the list of object columns of an INSERT statement, or the SET clause of an UPDATE statement.
Solution
Correct the syntax of the statement so that each column name is specified only once.
