The following three methods are provided for updating a table that has repetition columns:

• Updating an existing element (SET clause)
• Adding a new element (ADD clause)
• Deleting an existing element (DELETE clause)

To update a table that has repetition columns, specify the repetition column elements to be updated using the following format: repetition-column-name[{subscript| *}]. subscript indicates the element position.

This section describes the method for adding a new element.

Figure 2-15 shows an example of updating a table that has repetition columns. This example adds the element DATABASE to the qualifications of the employee named SMITH, BOB in a staff table.

Figure 2-15 Example of updating a table with repetition columns