Hi

Thanks for your replies.

Doing a HELP SELECT in admin cmd line tells that a subquery is valid.
I tried with a little more simple sql - with the same result :

adsm> select * from select node_name from nodes
ANR2904E Unexpected SQL key word token - 'SELECT'.

                       |
         ..............V..........................
         select * from select node_name from nodes

ANS8001I Return code 3.

adsm>

...and.........

adsm> select * from (select node_name from nodes)
ANR2908E Unexpected SQL punctuation token - '('.

                       |
         ..............V............................
         select * from (select node_name from nodes)

ANS8001I Return code 3.

adsm>


IBM, are select subqueries not valid ???

Regards, Carsten Moldrup