Re: Online & multiple DB's

>From: uunet!indcon!rickt >Message-Id: <9205140346.AA17043@relay2.UU.NET> >Subject: Online & multiple DB's >Date: Wed May 13 22:59:21 1992 >X-Informix-List-Id: <list.1178> >My question is: >If we went to the Online Engine, and if our two(or more) databases >were in the same dbspace(s), could we do queries that join two >or more databases/tables together? >select database1.table_a.col1, database2.table_b.col1 >from database1.table_a, database2.table_b >where database1.table_a.col0 = database2.table_b.col0 >Must we have STAR to do this? >Rick Tucker (616)457-8873 | ^^ T W I N P E A K S ^^ This, I think belongs in the FAQ list I'm generating. Here's my previous response to a question on this subject. *Date: Wed Mar 18 16:21:06 1992 *From: johnl (Jonathan Leffler) *Subject: re: Gaining access to data outside the current database * *>Message-Id: <199203181310.AA21293@tbird.cc.bellcore.com> *>From: uunet!hector.cc.bellcore.com!warren (saccente,warren j) *>Date: 18 Mar 1992 8:05 EST *>Subject: re: Gaining access to data outside the current database *>X-Informix-List-Id: <list.963> *> *>With Informix Online you can select from a remote db by refering to the *>table as DBNAME:TABNAME, but I believe that you cannot do any updating *>in this manner. *> *>Warren J. Saccente *>Bellcore * *Two additions to what Warren says: *a. Updatability depends on the version of OnLine, as in the table below. *b. You can also use synonyms to represent remote tables. A synonym looks * like a local table name but can resolve into a remote table name. * * eg: CREATE SYNONYM Owner1.Table1 FOR Database2@Machine2:Owner2.Table2 * *Can a single transaction access a non-current database? * * +==========+=========================+============================+ * |OnLine | Same OnLine System | Different OnLine Systems@| * |Version | Read Write | Read Write | * +==========+============+============+==========+=================+ * |4.00 | Yes | No | Yes | No | * +----------+------------+------------+----------+-----------------+ * |4.10 | Yes | Yes | Yes | No | * +----------+------------+------------+----------+-----------------+ * |5.00 | Yes | Yes | Yes | Yes | * +==========+============+============+==========+=================+ * * @ Requires Informix-STAR. * *Version 4.00 provides read-only access to other databases. If the other *database is part of the same OnLine system, Informix-STAR is not required. * *Version 4.10 provides read-write access to other databases which are located *in the same OnLine system without requiring Informix-STAR. It provides *read-only access to databases in other OnLine systems. * *Version 5.00 provides read-write access to other databases. If the *other database is not in the same OnLine system as the current (or home) *database, then the system must use Informix-STAR. Version 5.00 *automatically provides 2-phase commmit if a single transaction updates *more than one database in more than one OnLine system. Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>