DSF Return Codes › D05

D05

BAD ORDERED CHAIN

Reason:

The following occurred:

In DSF processing

A bad ordered chain was encountered.

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

One of the following:

• Delete the subject of the ordered relationship.
• Re-add and re-relate the objects of the relationships.
• Issue the DELRELAT command for the subject of the relationship with ALL in the qualifier and re-relate the objects.

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.