DSF Return Codes › D01

D01

SUBJECT OF A REQUIRED RELATIONSHIP

Reason:

The following occurred:

In DSF processing

You attempted to delete the subject of a required relationship.

In SQL processing

The SQL statement causes an occurrence or occurrences to be deleted from Datadictionary. At least one of the occurrences is the subject of a required relationship.

Action:

Perform the following:

In DSF processing

Delete the object(s) of the required relationship, unrelate the objects of the required relationship and relate them to another subject, or leave the entity-occurrences incomplete with ADDTERMI. Reissue the command.

In SQL processing

Run DDUTILTY for the active Datadictionary with -RPT DEFIN transactions to see if a user-defined relationship has been created where TABLE, VIEW, SYNONYM, CONSTRAINT, KEY, PLAN or STATEMENT is the required subject of that relationship.

Either delete the relationship definition from Datadictionary or delete the object of the required relationship before executing the SQL statement again.