Unix Technical Forum

Re: Can you have the same table in two SE databases?

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 ...


Go Back   Unix Technical Forum > Database Server Software > Informix

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-19-2008, 08:16 PM
Mark D. Stock
 
Posts: n/a
Default Re: Can you have the same table in two SE databases?


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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 10:23 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com