-534   THE PRIMARY KEY CANNOT BE UPDATED BECAUSE OF MULTIPLE-ROW UPDATE

Explanation

An UPDATE operation attempted to update a primary key on multiple rows of the object table.

An UPDATE statement updating the primary key cannot be used to update more than one row of the object table.

Note: This SQLCODE will only be issued for plans and packages bound prior to Version 5. SQLCODE -534 will not be issued for dynamic SQL or plans and packages bound with Version 5 or later releases.

System action

The UPDATE statement cannot be executed. The contents of the object table are unchanged.

Programmer response

Examine the search condition of the UPDATE statement to make sure that no more than one row of the object table is selected to be updated.

SQLSTATE

21502