Adding a Column to a Key

Maintaining Tables with Related Constraints › Impact of Changing Structure Definitions on Constraints › Adding a Column to a Key

Adding a Column to a Key

If you are adding a column to a key, the results vary depending on the type of constraint. This action has no effect on Check constraints. However, Foreign and Unique constraints cannot be updated this way.

Type of Constraint	Effect on Constraint
Check	Not applicable.
Foreign and Unique	Constraints are not allowed because the rebind recreates the key as it was before causing a new KEY to be added since the source of the constraints reflects the old column list. CA Datacom Datadictionary generates a DSF return code CON when you attempt to add a column to a key defined with these constraints. Drop the constraint before adding the column to the key.

Type of
Constraint

Effect on Constraint

Check

Not applicable.

Foreign and
Unique

Constraints are not allowed because the rebind recreates the key as it was before causing a new KEY to be added since the source of the constraints reflects the old column list.

CA Datacom Datadictionary generates a DSF return code CON when you attempt to add a column to a key defined with these constraints. Drop the constraint before adding the column to the key.