Problem with 7.30.UC5
Posted in 1998
Can somebody reproduce my problem?
We have two onlines defined in a NCR MP-RAS SVR4 UNIX System
with UNIX System V Release 4.0 Version 3.0
Engine: Informix Dynamic Server Version 7.30.UC5
INFORMIX-SQL Version 7.20.UD1
In sqlhosts we have:
ncr4 onipcshm cc ncr4
ncr4_tcp ontlitcp cc istarha
ncr5 onipcshm cc ncr5
ncr5_tcp ontlitcp cc istarch
and we have defined the services.
istarha 1528/tcp
istarch 1532/tcp
With two databases in both onlines: dbanameA and dbanameB
which have this tables:
IN dbanameA tableA
In dbanameB tableB
create tableA
(keyA char(1))
create tableB
(keyB char(1))
We are in the first online (INFORMIXSERVER=ncr4)
when we type:
$ isql dbanameAThe select is
select * from tableA where keyA="0"
and a.keyA not in (select b.keyB from dbnameB@ncr5_tcp:tableB b
where b.keyB=a.keyB)
The message we receive is:
25587 Network receive failed
Thanks in advance