Re: Meshing two databases

Posted in 1997

Mark D. Stock — Fri, 18 Jul 1997 10:08:17 +0200 — source: Informix-list mailing list archive (1991-1998)

loubier@sparky.nimh.nih.gov wrote: > > I am looking to combine to databases in some way so as to make them > appear as one for the sake of queries. The tables of the two > databases > are conceptually the same with some small physical or layout > differences, ie table and field names. I have looked into Informix's > Metacube, but I am not certain that this allows concurrent access to > two > different databases. If someone has a solution to this problem, please > let me know. A bit more info on products and versions would be useful, but have you looked at synonyms? Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //| | +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+