Updating Supertype and Subtype Data

Existing supertype-subtype record constellations may be updated in three ways:

•Supertype values are changed.

•Subtype values are changed.

•New subtypes are selected for an existing supertype, or existing subtypes are de-selected.

Subtypes are selected or de-selected for an existing supertype by:

•Selecting or clearing subtype indicators (check boxes).

•Inserting or deleting records in windows based on the subtype table.

•Indirectly, by issuing an INSERT INTO subtype or DELETE FROM subtype statement. Such a statement could be issued in a constraint.

These manipulations are treated as UPDATEs to the record constellation. Transitional constraints defined on the record constellation are evaluated if the Fire On Update flag is set.

A possible exception is adding new subtype data to an existing supertype constellation. If this new data is inserted through a window based on the subtype, or inserted indirectly through a constraint, it is handled as INSERT rather than UPDATE if the Update Supertype on Insert deployment configuration parameter in the Authorizer is set to No.