Helen,

>>Here is a quote from the DB2 docs:
>>
>>"A delete or update rule of RESTRICT is enforced before all other
>>constraints including those referential constraints with modifying
>>rules such as CASCADE or SET NULL. A delete or update rule of NO
>>ACTION is enforced after other referential constraints. There are very
>>few cases where this can make a difference during a delete or update."
>>
>>Talk about subtle! :-) I am not sure about Oracle.

H> Subtle indeed! That description sounds as though DB2 lets you
H> declare multiple actions for a single constraint. Bizarre!

Apparently no, but it lets you declare multiple FK constraints on the
same fields referencing the same table.

Ciao
--
Nando Dessena
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================