When a condition is specified for data updating, all rows that satisfy the condition are updated. To update by specifying a condition, the WHERE clause must be specified in the UPDATE statement.

If the table is partitioned by key ranges, the values in the column being used as the key cannot be updated.

The following figure shows, as an example of updating with a condition specified, the procedure for updating to 20 the quantity of each item whose product code in the stock table is 411M.

Figure 2-13 Example of updating with condition specified