Re: Urgent! synonym question...
AJAYP wrote:
>
> Hi,
> 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.
No this should be doable without trouble. Assume you have table: fred
in database: flintstones in a 7.xx instance named: bedrock then and
want a synonym in the current database for this table named frederick:
create synonym frederick for flintstones@bedrock:fred;
Voila!
Art S. Kagel