How to treat several identical database as one.

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