Re: Link to a table on another DB

In what version were synonyms removed from SE? rod ----- 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/ > >