Re: Multiple dbs and one 4gl program

Posted in 1995

Kerry Sainsbury — Thu, 19 Jan 1995 20:13:13 +1200 — source: Informix-list mailing list archive (1991-1998)

In article <3fhpee$oqd@tattoo.sccsi.com>, goldberg@sccsi.com (Sgoldbrg) wrote: > In article <3fdijm$593@emory.mathcs.emory.edu>, pp@ciop.waw.pl (Pawel Pietrusinski) says: > > > >Is it possible to access multiple databases from > >within one 4gl program (for example perform > >a join on tables from two different databases)? > > > Pawel, > > In the select statement that has the 2 tables, use the construct: > > databasename:tablename .... > > Precede the table names with the database names. This technique works for Online Engines. For a SE technique you might want to consult the FAQ. Regards, Kerry S --------------------------------------,------------------------------------- Kerry Sainsbury, kerry@kcbbs.gen.nz | THE INFORMIX FAQ Quanta Systems, Auckland, New Zealand | kcbbs.gen.nz:/informix/* | mathcs.emory.edu:/pub/informix/faq/* +64 9 377-4473 (work) 276-5546 (home) | quasar.ucar.edu:/?