Re: Informix error 568

On Tue, 11 Aug 1998, sanjeev sagar wrote: > Informix IDS 7.30.UC2 on Solaris 2.5.1 > > I am having one stored procedure which simply do a > copy of the table from one database to another > database. The problem is > > Database1-logging > Database2-nologging That certainly is a problem. Basically, you cannot do anything with two different databases that have different logging levels. You can't evern transfer data between a buffered logging database and an unbuffered logging database. The only exception to this rule is the SysMaster database in OnLine (IDS); you can access that from any mode of database. > If i use the that stored procedure in the above > mentioned scenarion it gives me error > > 568- Cannot reference an external database without logging. > [...] > I do not know any workaround for this. I would appreciate any help > for the same. You will have to unload from one database and load into the other database, or write code which makes two separate connections to the databases and shuttles data from the first database using one of the connections to the second database using the other. I'd use LOAD and UNLOAD -- its simpler. Yours, Jonathan Leffler (jleffler@informix.com) #include <witticism.h> Guardian of DBD::Informix v0.59 -- http://www.perl.com/CPAN Informix IDN for D4GL & Linux -- http://www.informix.com/idn