Updating Table Attributes

Maintaining Tables with Related Constraints › Impact of Changing Structure Definitions on Constraints › Updating Table Attributes

Updating Table Attributes

When you update TABLE entity-occurrence attributes, changing AUTHID, SQLNAME or DATACOM-NAME attribute-values affect constraints. Updating other attributes does not affect constraints.

Attribute	Type of Constraint	Effect on Constraint
DATACOM- NAME	Check, Foreign, and Unique	Not allowed if the table has constraints. CA Datacom Datadictionary generates a DSF return code CON when you attempt to update this attribute for a table with these constraints. Drop the constraint before updating this attribute.
AUTHID or SQLNAME	Check, Foreign, and Unique	An SB9 error is returned if the change is attempted in PROD status. If the change is attempted in TEST status, a CON error occurs if any constraints exist on this table.

Attribute

Type of
Constraint

Effect on Constraint

DATACOM-
NAME

Check,
Foreign, and
Unique

Not allowed if the table has constraints.

CA Datacom Datadictionary generates a DSF return code CON when you attempt to update this attribute for a table with these constraints. Drop the constraint before updating this attribute.

AUTHID or
SQLNAME

Check,
Foreign, and
Unique

An SB9 error is returned if the change is attempted in PROD status.

If the change is attempted in TEST status, a CON error occurs if any constraints exist on this table.