Re: Multiple dbs and one 4gl program

Posted in 1995

Richard Spitz — 20 Jan 1995 09:16:27 GMT — source: Informix-list mailing list archive (1991-1998)

Stefan Gutsche (sg@ivu-berlin.de) wrote: : Yes it is possible to access two or more databases with one statement. : You must use the ":"-Notation: : SELECT a.row, b.row FROM db1:tab1 a, db2:tab2 b : WHERE a.row = b.row Doesn't this work only with Online and I-Star? What about if one DB is in Online and the other in an SE system? Regards, Richard -- +----------------------------+-------------------------------------------+ | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3421 | | Klinikum Grosshadern | FAX : +49-89-7095-8886 | | 81366 Munich, Germany | | +----------------------------+-------------------------------------------+