IDS2000 error messages, in case of SQL referencing multiple servers, do leave
something to be desired.
For example, if the column names are not specified correctly (typos), one
could get errors as follows
9931: Byte and Text datatypes in row and collection types not allowed.
999: Not implemented yet.
217: Column (talid) not found in any table in the query (or SLV is undefine
999 usually occurs when the column in the remote database has been specified
incorrectly. 9931 & 217 occur when the mistake is made on the local database.
Further, the error message also seems to depend on how the optimizer executes
the query. For example,
is equivalent to
where not exists (
where a.tab1id = b.tab1id);
But, the error messages, in case of an incorrect column name, differ.
Of course, its eminently possible that there are other reasons for which the
999 is being spouted out. If you do find something else, please let us all
> 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:
> All other tables in this database are fine.
> Any ideas, please...