-121 THE COLUMN name IS IDENTIFIED MORE THAN ONCE IN THE INSERT OR UPDATE OPERATION OR SET TRANSITION VARIABLE STATEMENT
Explanation
The same column name is specified more than once, either in the list of object columns of an insert operation, in the SET clause of an update operation, or in a SET transition variable statement.
- name
- The name of the column.
This error can also occur during an update or insert operation on a view, when one column of the view is based on the same column of a base table.
System action
The statement cannot be processed. No data was inserted or updated in the object table.
Programmer response
Correct the syntax of the statement so that each column name is specified only once.
SQLSTATE
42701