The UPDATE statement updates the values of specified columns in rows of a table or view. Updating a row of a view updates a row of its base table, if no INSTEAD OF UPDATE trigger is defined on this view. If such a trigger is defined, the trigger will be executed instead.
There are two forms of this statement:
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.