Re: Insert into ... select from , and logging

On Mon, 25 Sep 2000, Neil Truby wrote: >> > Is there any way around this (569 Cannot reference an external database >> > without logging > >> You must maintain a separate connection to each database, as dbcopy does, >> to be able to use data from mulitple databases with different logging >> status. > >Er, does that mean "No"? There's nothing clever I can do with separate >server names? Yes, that means "No"! No, there's nothing you can do with separate server names. I didn't mention it, but the sysmaster database can be accessed with databases in any logging mode. I'm not sure whether there's anything devious you can do with this information -- it almost certainly would not be more efficient than using two connections, though. -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"