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.

Figure 2-14 shows an example of updating on a row basis. Here, the quantity of each item in the stock table whose product code is 411M is updated from 12 to 20; the new value is specified in the embedded variable (:YROW).

Figure 2-14 Example of updating on a row basis