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.

Figure 2-13 shows an example of updating with a condition specified. Here, the quantity of each item whose product code is 411M is updated to 20.

Figure 2-13 Example of updating with condition specified