Inserting Supertype and Subtype Data
You can insert new subtype data:
INSERT INTO <subtype>
UPDATE <supertype> SET <subtype indicator> = 'Y'
statement. This statement could be issued from a constraint.
In all cases you need to provide values for any mandatory subtype columns.
If the record constellation is subject to one or more totality rules, you are allowed to insert a new supertype record only if you also set the necessary subtype(s) and provide values for its mandatory columns.
If the record constellation is subject to one or more exclusivity rules, you are allowed to add subtype data only if this does not violate these rules.
How USoft Developer handles new subtype data added to existing supertype data depends in part on the Update Supertype on Insert deployment configuration parameter setting in the Authorizer.