Re: How to treat several identical database as one.

What version of the DB? If 7 why not use DR? ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov DTSI, Inc. Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On Tue, 3 Sep 1996, David Williams wrote: } } } Our Informix-4GL based system will soon be used at several sites in } the same organisation i.e. several machines each with a copy of the } application and a database. We want to run a PC-based reporting tool } that can report across all the databases. } } Our first idea was to create a new database with views of the form } } create view job as } } select * from server1@machine1:job } union } select * from server2@machine2:job } union } select * from server3@machine3:job } } } i.e. create a 'pseudo-table' which appears as all the data from all } the job tables on the three servers. } } Unfortunately views do not support unions. Any ideas???? } } We don't want to replicate the data just make all the similar tables } appear as one table so the PC-base reporting tool (GQL) can be used } by 'normal' users? i.e. non-techines. } } -- } David Williams }