The following three methods can be used to update information in a table:

• Updating the row indicated by the cursor
• Updating only those rows that satisfy a condition
• Updating on a row basis (for table with FIX attribute only)

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

Organization of this section

2.4.1 Updating using a cursor

2.4.2 Updating with a condition specified

2.4.3 Updating a table with the FIX attribute

2.4.4 Updating a table with repetition columns