Re: Loging and No Log Data Base

>>>>> "Joe" == Joe Quan <100561.465@compuserve.com> writes: Joe> ANSWER: Joe> Suppose you want to do Joe> insert into tablex... Joe> select ... Joe> from tabley Joe> where ... Joe> tablex is in database X, and tabley is in database Y. Joe> You can create a synonym 'tabley' in the database X which links to Joe> the 'tabley' in the database Y, or vice verse (RTFM). To your Joe> Window program (or be it a character based program) , it only access Joe> one database ( X or Y). Joe> Better still, these two databases can be in two different instances Joe> and two different servers. Of course, they can have different Joe> logging mode. What version of Informix Online are you referring to now? In version 5.0X it does not work as you describe above. The two databases must still have the same logging mode. Synonyms doesn't matter at all in this regard. How about 7.X? I thought this was supposed to be the same in 7.X? -- 'yvind Gjerstad Systems dept Tollpost-Globe AS N-6301 'ndalsnes/Norway E-mail: ogj@it.tollpost.no Phone: +47 7122 6663 Fax: +47 7122 6694