Re: SELECT BETWEEN DIFFERENT SERVERS

In article <75ss67$scs$1@ntd.co.ru>, dimam@olma.co.ru (Makunin Dmitry) wrote: > Hi > I want make this query : > SELECT * FROM appdb@mfcinf:t_1 ;> But it do'nt work . Well, that depends.. If the server you acre conected to has a different logging mode (yes, no, ANSI) than the logging mode of the remore server - like mfcinf in the above example, then it will not work. Similarly, it the current server is IDS and the remote server is SE, it will also fail. On the other hand, if both the current and remote servers have the same logging mode, the query runs magnificently! With no other information than "it doesn't work" it had to guess at exactly what your situation is. But what I have described is very common. I had thought that by now Informix would have lifted this restriction on cross-platform read-only queries but, alas, it appears they have not received the obligatory circular tuitt.. ;-) -- -- Jake (Retrospectively realizes there is no future in hindsight) +------------------------------------------------------------+ | The expedient performance of a task with excessive concern | | regarding its duration-to-completion engenders a virtual | | certainty of diminished benefit therefrom. | | -- Benjamin Franklin (but he said it in 3 words) | +------------------------------------------------------------+