RE: Informix error 568

There is by-pass way to do this. use unload to 'file' select ... to unload the table in database 1 into a flat file and load the flat file into database 2 table by load from 'file' insert into... tong > ---------- > From: sanjeev sagar[SMTP:sanjeevsagar@rocketmail.com] > Sent: Tuesday, August 11, 1998 2:33 PM > 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 >