This is a discussion on Re: Can you have the same table in two SE databases? within the Informix forums, part of the Database Server Software category; --> Andrew Hamm wrote: > malcolm.iiug wrote: > >>A client of mine wants to use the same table in two ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Andrew Hamm wrote: > malcolm.iiug wrote: > >>A client of mine wants to use the same table in two different >>databases in two different databases. Could they do so by pointing >>dirpath for the table in each database to the same c-isam file? And >>what are the predicted problems with doing so? >> >>I suspect we will have to wait for Jonathan to answer this one. > > > Doesn't SE support remote synonyms? I'm SURE it does..... No, only local. > It supports remote database access in the form database:table doesn't it, > as long as the database can be found in the DBPATH? No, it doesn't. You can connect using the syntax database@databaseserver, but basically you can only connect to one database at a time. Unless they've changed it in more recent versions. It all seemed so much easier to understand when we had INet for SE and IStar for OnLine. :-) Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ sending to informix-list |