I Admin ref manual states that correlated subqueries are not supported.
I don't you if your query is one, but I suspect it is and that is the problem.


--
--------------------------
--------------------------
Bill Colwell
Bill Colwell
C. S. Draper Lab
Cambridge, Ma.
bcolwell AT draper DOT com
--------------------------
In <C12567B6.0041D638.00 AT dencop1.csc DOT dk>, on 07/22/99
In <C12567B6.0041D638.00 AT dencop1.csc DOT dk>, on 07/22/99
   at 02:21 PM, Carsten Moldrup <cmoldrup AT CSC DOT DK> said:

>Hi

>I am trying to do a SELECT FROM subquery...... which wont work.
>ADSM does not like the () in this sql - removing them gives an ANR2904E
>Unexpected SQL key word token - 'SELECT'.
>Any ideas ?   ADSM server is 3.1.2.20 on MVS.

>Regards, Carsten Moldrup

>here's the sql...

>select -
>       table1.node_name  -
>      ,table1.platform_name     -
>      ,table2.fs as "Filespaces" -
>      ,table2.mb as "MB Capacity"  -
>from -
>       nodes as "table1"  -
>      ,( -
>        select  -
>               node_name -
>              ,count(*) as "fs"  -
>              ,sum(capacity) as "mb"  -
>        from -
>               filespaces -
>        group by node_name -
>       ) -
>         as "table2"
>where -
>       table2.node_name=table1.node_name -
>order by 2,1