Re: Meshing two databases

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. >Cheers >-- >Mark. Beers! -- Jake (In pursuit of undomesticated aquatic avians) +----------------------------------------------------------+ |Aside from that, how did you enjoy the play, Mrs. Lincoln?| +----------------------------------------------------------+