RE: "Not implemented yet" error
We are getting very similar errors on our machine. I only picked this up
with IDS2000, never in 7.
If I run your select, it works fine on my machine. I can't do the following
select though -
(joining 2 tables on different servers)
select a.col1, b.col2
from tab1 a, db2@server2:tab2 b
where a.col4 = b.col5
With this one I get the -999 (not implemented yet) error-
Dirk
Reach Technologies
-----Original Message-----
From: owner-informix-list@iiug.iiug.org
[mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Elena Korol
Sent: Tuesday, November 21, 2000 1:35 AM
To: informix-list@iiug.org
Subject: "Not implemented yet" error
If anyone have seen this error, would you, please help me out:
- [Informix][Dynamic Server 2000][content] SQL Error (-999) : Not
implemented yet.
Error comes out when I am trying to run select on two identical (replicated
tables) on two different servers ( one is a backup server).
SQL looks like this:
select * from db1@server1:tab1 a where a.tab1id not in ( select tab1id fromdb1@server2:tab1);
All other tables in this database are fine.
Any ideas, please...
Elena.
e-mail: ekorol@styleclick.com