Hi all,

I'm facing some strange SQL problem while querying COLLOCGROUP table,
and can't find out what is happening here ...
I've built a script (q_collocgroup) which looks like :

select collocgroup_name from collocgroup where node_name=upper('$1')
select node_name, collocgroup_name from collocgroup where
collocgroup_name in (select collocgroup_name from collocgroup where
node_name=upper('$1'))

For some nodes, the scripts works perfectly :

run q_collocgroup asbrs000

COLLOCGROUP_NAME  
------------------
AIX_0_6           

NODE_NAME              COLLOCGROUP_NAME  
------------------     ------------------
ASBRS000               AIX_0_6           
PACRS070               AIX_0_6           
PACSP030               AIX_0_6           
   

For other ones, the second query fails :

run q_collocgroup old_pacrs111

COLLOCGROUP_NAME  
------------------
AIX_INACTIVE      
ANR2034E SELECT: No match found using this criteria.
ANR1462I RUN: Command script Q_COLLOCGROUP completed successfully.

I tried an equivalent query :
(SELECT COLLOCGROUP.NODE_NAME, COLLOCGROUP.COLLOCGROUP_NAME
FROM COLLOCGROUP WHERE (((COLLOCGROUP.COLLOCGROUP_NAME)=(SELECT
COLLOCGROUP.COLLOCGROUP_NAME FROM COLLOCGROUP WHERE
(((COLLOCGROUP.NODE_NAME)=[enter node_name])))));
using MS Access and ODBC driver, with the same problem

Does someone have an idea of what is happening here ?
Thanks in advance !
Cheers.

Arnaud 

************************************************************************
******
Panalpina Management Ltd., Basle, Switzerland, CIT Department
Viadukstrasse 42, P.O. Box 4002 Basel/CH
Phone:  +41 (61) 226 11 11, FAX: +41 (61) 226 17 01
Direct: +41 (61) 226 19 78
e-mail: arnaud.brion AT panalpina DOT com
************************************************************************
******