Re: Distributed key constraints
From: <lennart_at_kommunicera.umea.se>
Date: 27 Apr 2005 13:17:01 -0700
Message-ID: <1114633021.153482.45630_at_o13g2000cwo.googlegroups.com>
Date: 27 Apr 2005 13:17:01 -0700
Message-ID: <1114633021.153482.45630_at_o13g2000cwo.googlegroups.com>
Mark D Powell wrote:
[...]
> Oracle definitely does not. You have to use a table
> trigger to enforce integrity between tables in distributed databases.
> I do not ever remember dealing with a FK to a remote object with DB2
or
> SQL Server either but my experience with those products in not as
deep.
>
Neither does DB2. You can specify a f.k. towards a nickname (table in another db), but you cannot have it enforced. Excerpt from the manual:
"The constraint is enforced by the database manager. ENFORCED cannot be specified for a functional dependency (SQLSTATE 42621). ENFORCED cannot be specified when a referential constraint refers to a nickname (SQLSTATE 428G7)." /Lennart Received on Wed Apr 27 2005 - 22:17:01 CEST