When a table with the FIX attribute is updated, an entire row can be updated as fixed-length data. To update on a row basis, ROW must be specified in the SET clause of the UPDATE statement.

Updating on a row basis reduces updating overhead for each column, so it enhances access performance.

The following figure shows, as an example of updating a table on a row basis, the procedure for updating from 12 to 20 the quantity of each item in the stock table whose product code is 411M by specifying the new value in an embedded variable (:YROW).

Figure 2-14 Example of updating on a row basis