RE: Informix error 568
At the IIUG web site is a file of utilities from Art Kagel (utilak2?) that
has a dbcopy program. This will do exactly what you wish.
-----Original Message-----
From: sanjeev sagar [mailto:sanjeevsagar@rocketmail.com]
Sent: Tuesday, August 11, 1998 4: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