Re: Creating a synonym from Online to SE

>From: kevinpot@sbservices.com >Date: Mon, 03 Feb 1997 10:31:07 -0600 >X-Informix-List-Id: <news.33368> > >Has anyone out there ever successfully created a synonym from an Online >(5 or 7) database to an SE Database (5 or 7). We have tried OD7 to SE 7 >and ONL 5 to SE 5 with no luck. We are getting an error that states the >syntax we are using is not allowed in this server. Informix has given >us mixed answers if this is possible. Has anyone been able to get this >working? I think it should be impossible. Why? To create a synonym between to OnLine databases, the two databases must have exactly the same level of logging (eg, both buffered log, or unbuffered log, or both mode ansi, or both unlogged). If you don't have the same logging level, you get an error. In fact, if you even try to SELECT data from a table in a database with different logging, you get anerror such as "-568: Cannot reference an external database without logging" (from a logged database, referencing a table in an unlogged database). What OnLine logging level corresponds to each of the SE logging levels? There is no correspondence between the logging levels, even unlogged, because there are things which OnLine can handle which SE cannot (such as rolling back DDL statements), and there are differences in the way they handle constraint checking. Consequently, you cannot create synonyms between OnLine and SE. However, with 6.00 and above, you can use multiple connections, one to an SE database and to OnLine. Of course, this is not the same as providing a synonym, but a single program can access the data from two disparate databases. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>