RE: Informix error 568

Posted in 1998

Ashby, David — Wed, 12 Aug 1998 09:09:04 +1000 — source: Informix-list mailing list archive (1991-1998)

Sanjeev, The only way to do this without turning logging on the second database is to unload to a file. Regards, David Ashby -----Original Message----- From: sanjeev sagar [mailto:sanjeevsagar@rocketmail.com] Sent: Wednesday, 12 August 1998 7:33 To: informix-list@iiug.org Subject: Informix error 568 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 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 used dbaccess in dtabase1 and issue one select query like select * from database2:tablename It also give me same error. I do not know any workaround for this. I would appreciate any help for the same. Sanjeev _________________________________________________________ DO YOU YAHOO!? Get your free @yahoo.com address at http://mail.yahoo.com