You can use the UPDATE statement to modify column values in existing rows of an Object File System table. See SQL Data Manipulation Language for details of syntax and usages of the UPDATE statement.
For an Object File System table, an UPDATE statement updates the data in a table and is processed as a complex update, that is, old data is deleted and new objects are created for the new rows with updated column values.
All variations like UPDATE without any condition, with single-table WHERE condition involving only the target table and WHERE condition involving one or more non-target tables are supported.
The objects that qualified for UPDATE are logged in delete index and are eligible for removal at the end of their retention period. A background task eventually removes such deprecated objects.