Re: Design Question: Keys using multiple Databases

Jens Ebert wrote: > > We are a team who is developing database applications with Informix-Online > 7.23. > We are looking for Informix-Developers with experience in Informix who > help us to find a solution for our problem. > > We are designing multiple databases. We intend to design a > database with general (static) tables, that are used from several of our > applications. Beside this database, each application owns one private. > > The tables in the private databases have associations with tables in the > general database. This would mean that we need foreign-keys that span two > databases: The primary key of tables in the general database should be a > foreign key for tables in the private database. > > We would appreciate any idea how we can implement this concept without > loosing the > primary/foreign-key relationship. > > Thank you, > Jens I'm not sure why you need separate databases but here's a couple of other ways you might think about: 1. Use mode ANSI and have separate schemas for the static tables. I wouldn't recommend mode ANSI unless you really do need it. 2. Copy the static tables to all the databases using the new replication feature - I think it's in 7.3 though. -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk --- My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/