Re: Using synonyms to update remote tables

Posted in 1997

david.ashby@workcover.nsw.gov.au — 19 Dec 1997 16:53:14 -0500 — source: Informix-list mailing list archive (1991-1998)

Ivan, I use synonyms to link two of my databases. The databases are on different machines and different releases of 7.2. Everything has worked so far, ie: insert, updates, deletes and selects. Regards David Ashby ______________________________ Reply Separator _________________________________ Subject: Using synonyms to update remote tables Author: Ivan Lopes <ivan.lopes@rio.rsl.com.br> at WCA-INET Date: 18/1/97 2:13 PM Hi, Anyone has some experience in using synonyms to update remote tables??? Ex: Server InstanceA Database db1 table CLIENT Server InstanceB Database db2 synonym CLIENT for db1@InstanceA:CLIENT I need to use the synonym CLIENT to select/update the table CLIENT. Any comments? TIA Ivan Lopes DB Solution - Rio de Janeiro - Brazil