Update_Supertype_On_Ins (Additional Parameter)

Previous Next

See Also

This is where you specify whether inserting a subtype for an existing supertype must be considered as an UPDATE on the whole constellation.

By default, Update_Supertype_On_Insert is set to No. This means that if a subtype is inserted for which the supertype already exists, an error message will appear because the key is not unique.

If Update_Supertype_On_Insert is set to Yes, inserting a subtype for an existing supertype will be considered as an UPDATE on the whole constellation. In this update the subtype indicator column(s) will be set as well. Note that in this case only those transitional constraints that have been specified as Fire On Update will be fired.