-121 THE TARGET name IS IDENTIFIED MORE THAN ONCE FOR ASSIGNMENT IN THE SAME SQL STATEMENT
Explanation
The same name is specified more than once as a target for an assignment.
- name
- The name of the target of the assignment.
This situation can occur
when a target name is specified more than once in any of the following contexts:
- In the list of object columns of a data change operation
- In the SET clause of an update operation
- In the SET statement for assignment to a transition variable
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 assigned.
Programmer response
Correct the syntax of the statement so that each target name is specified only once.
SQLSTATE
42701