Re: Urgent! synonym question...
Posted in 1998
Jonathan Leffler — — source: Informix-list mailing list archive (1991-1998)
On Thu, 16 Jul 1998, AJAYP wrote:
> Can someone tell me how do we create a synonym on an Informix 5
> database table in another database which resides on Informix 7 ? Do I
> need to make any special settings ?
> Any help or pointers will be welcome.
Can you access the remote database table using dbase@v7server:owner.table?
If not, you need to get your configuration set up so that you can. You may
need to be running I-Star on the V5 server box.
If you can, then synonym should be creatable as usual:
CREATE SYNONYM newname FOR dbase@v7server:owner.oldname;
Yours,
Jonathan Leffler (jleffler@informix.com) #include <witticism.h>
Guardian of DBD::Informix -- see http://www.perl.com/CPAN