Re: Error -568: Cannot reference ext.db w/o logging
In article <5ea6qa$fvh$1@Mars.mcs.net>, David Gilbert <xanadu@MCS.COM>
writes
>Greetings All:
>
>When I run this:
>
> database db_no_log;>
> select * from db_with_log:sysusers>
>I get this:
>
> -568: Cannot reference an external database without logging>
>I understand why Informix does this, but is there anyway to get this
>to work if all I want to do is a SELECT?
>
>Thanks in advance.
>
>--
>David Gilbert (xanadu@mcs.net)
>
>
You could cheat:-
database db_no_log
create temp table my_temp
(
<fill in schema of db_with_log:sysusers>
)
database db_with_log
insert into my_temp select * from sysusers
database db_nO_log;
PS Won't necessarily work on all engines!!
--
David Williams