DSF Return Codes › D02

D02

LAST OCCURRENCE OF A REQUIRED RELATIONSHIP

Reason:

The following occurred:

In DSF processing

You attempted to delete the last entity-occurrence 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

Follow the action specified in the previous message (D01).

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.