Determining Occurrence Count

The occurrence count of every repeating data item must be determined each time a record is inserted.
The Relativity DBMS will try the following:
  • If a column is defined on the ODO control item, the value will be set explicitly on each INSERT statement. The column must either not be marked as nullable or have a default value.
  • If a column is defined on a variable-length group that contains the repeating data item, the occurrence count will be computed from the length of the column value.
  • If neither of the above applies, but the ODO control item has a default value, the item's default value will be used.
Note: One of these conditions must be applicable or the table is not insertable.