Re: Multiple Databases in SQL (Online 5.07)

Posted in 1997

Richard Spitz — Fri, 10 Oct 1997 09:59:33 +0200 — source: Informix-list mailing list archive (1991-1998)

Jonathan Leffler wrote: > SELECT T1.SomeCol, T2.OtherCol > FROM somedbs@server:'owner'.tablename T1, > otherdbs@othersvr:'user'.tothertable T2 > WHERE T1.PkCol = T2.FkCol Maybe it is important to add that Informix-STAR is required on both servers for this functionality and that $INFORMIXDIR/etc/sqlhosts needs the correct entries for "server" and "othersvr" for this to work. Regards, Richard -- +--------------------------+------------------------------------------+ | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3413 | | Klinikum Grosshadern | FAX : +49-89-7095-8886 | | 81366 Munich, Germany | GSM : +49-172-8933578 | +--------------------------+------------------------------------------+