Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Jonathan Leffler — — source: Informix-list mailing list archive (1991-1998)
Gsong,
You asked two questions about Foreign Keys...
>From: gsong@aol.com (Gsong)
>Date: 11 Jan 1996 20:08:40 -0500
>X-Informix-List-Id: <news.20205>
>What is the proper method of referencing the primary key of a table in
>another database in Informix OL 7.x?
>From: gsong@aol.com (Gsong)
>Date: 12 Jan 1996 05:32:15 -0500
>X-Informix-List-Id: <news.20216>
>How do you make a foreign key constraint to a table outside of the current
>database. Is this possible?
It is not possible to create foreign key constraints across databases,
whether they are colocated in the same server or located in two different
servers, as you have already discovered to judge from your questions.
Yours,
Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.