Re: foreign key pointing to multiple (varying) tables
From: Serge Rielau <srielau_at_ca.ibm.com>
Date: Wed, 27 Sep 2000 14:44:36 -0400
Message-ID: <39D24014.C26E8930_at_ca.ibm.com>
Date: Wed, 27 Sep 2000 14:44:36 -0400
Message-ID: <39D24014.C26E8930_at_ca.ibm.com>
Have you considered using typed tables in DB2 V7.1?
You can create a hierarchy of typed tables and ceate the RI constraint
in the root.
All subtables will inherit.
Cheers
Serge
-- Visit the DB2 UDB and DB2 Connect Online Support site at: http://www.ibm.com/software/data/db2/udb/winos2unix/supportReceived on Wed Sep 27 2000 - 20:44:36 CEST