FW:

One reason we use synonyms is - We have about 9 different databases, and some of them share the same tables. Instead of duplicating these tables on all the databases, we have them in one database with synonyms pointing from the other databases to the one containing the tables. Another reason is also having old archive tables on a seperate instance of Informix. Instead of hardcoding database@server:tablename in the programs to access the remote tables, we use synonyms pointing from the local datase to the remote database, so in the programs you will only address "local tables". Dirk Reach Technologies -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Dusty Spellman Sent: Friday, December 01, 2000 9:42 PM To: informix-list@iiug.org Subject: I have been reading up on the Informix SQL extension CREATE SYMONYM, and although I understand the mechanincs of a synonym, I cannot think of a good application for them. Does anyone use them? ____________________________________________________________________________ _________ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com