Re: Link to a table on another DB

Rodney Sheppard wrote: > In what version were synonyms removed from SE? No version. But inter-database synonyms have never been supported. Intra-database - yes. Inter-database, no. > > ----- Original Message ----- > From: "Jonathan Leffler" <jleffler@earthlink.net> > To: <informix-list@iiug.org> > Sent: Tuesday, May 20, 2003 1:11 AM > Subject: Re: Link to a table on another DB > > > >>Colin Bull wrote: >> >>> Ferro wrote >>> >>>>On my ids I have 2 db: NEW and OLD. >>>>The 2 db have the same tables. >>>>The data in VARY table are different from NEW >>>>and OLD db, but the data in SAME table are >>>>the same in 2 db. >>>>So I ask me: why have I to duplicate the data in >>>>table SAME? >>>>Is there a way to create, on NEW db, a link from >>>>NEW.SAME table to OLD.SAME table? >>>> >>>>In other way, on my program I need to refer >>>>on NEW db, but the data should reside on >>>>OLD db. >>>> >>> >>>Synonyms are what you need. >>> >>>Instead of create table command in database2 d0 - >>>create synonym table1 for database1@on_server1_tcp:table1;>> >>The only thing to watch is SE - no synonyms there. You can achieve >>more or less the same effect with links (symbolic or hard), but you >>have to be extremely careful. Doing so won't be supported. That >>doesn't stop it working, of course. But backups, recovery, etc need >>to be thought about. >> >>-- >>Jonathan Leffler #include <disclaimer.h> >>Email: jleffler@earthlink.net, jleffler@us.ibm.com >>Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/ >> >> > > > -- Jonathan Leffler (jleffler@earthlink.net, jleffler@us.ibm.com) #include <disclaimer.h> Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/