Re: How to treat several identical database as one.

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. > We are not using Informix-4GL. I can't really help. But, our workaround for view not supporting unions is to write a stored procedure which union all similar tables, and then execute the stored procedure from the client workstaion. Will it work? Chao