Updating a table, the update must be ignore if it causes a duplicate primary key

[njohn14]

Hi,

I have a Teradata table I want to update. It has 2 columns as its primary key. I want to update one primary key column.
If the update would cause there to be a duplicate primary key, I want the update to skip updating that particular record and move on to updating the next record.

Thank you!

 

[njohn14]

Please could anyone suggest a query that would do this?