The following rules apply to SQL UPDATE operations when modifying an existing record in Relativity:
- A column cannot be updated if it is defined on a subscript item.
- If any column is defined on a repeating data item with unbound subscripts, then the only columns that are updatable are those
defined on repeating data items with the same unbound subscripts.
- A column cannot be updated if it is associated with a data item that overlaps the file's primary key.
- A column cannot be updated if it is associated with a data item that overlaps the file key which the Relativity DBMS is using
and if the file's primary key permits duplicates.
- A column cannot be updated (or inserted, for that matter) if it is a date type (not a date-time type) and it specifies a date-time
transform function or it is defined on a data item that specifies a date-time transform function.