Re: Meshing two databases

Jacob Salomon wrote: > > Mark D. Stock wrote: > > > >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? > > Mark, > > I think this man needs a view on a union more than a synonym. His > stated desire is to treat the two tables as one for the purpose of > some > queries. I don't recall the most recent comment on a view over a > union > for DSA 7.2 or Universal Server, but I think if the word would have > been > "YES" I would have remembered it. You may well be right, but the question clearly asked about databases, NOT tables: > >>I am looking to combine to databases in some way so as to make them ^^^^^^^^^ ^^^^^^^^^ > >>appear as one for the sake of queries. ^^^^^^^^^^^^^ and combining two databases to me, means making the tables from both available in one. Also, something about the subject as well. :-) But I have also heard people refer to tables as databases before. 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"!|/ ////////| +----------------------+-----------------------------------+-----------+