Thank you. I tried and it works.

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Dmitry
Sent: Sunday, February 14, 2010 4:57 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] help sql tsm 6.1.3.1 windows servers

Hana, This is correct request
select   a.node_name  from filespaces a, nodes b where 
b.node_name=a.node_name
-- 

Dmitry Dukhov
Siberia Software SL
http://www.s-iberia.com


On 14.02.2010 17:33, Hana Darzi wrote:
> Hello all,
>
> Why this query do not work in tsm 6.1.3.1 ?
>
> select   filespaces.node_name  from filespaces
>
> ANR0162W Supplemental database diagnostic information:  -1:42S22:-206
> ([IBM][CLI Driver][DB2/NT64] SQL0206N  "FILESPACES.NODE_NAME" is not valid in
> the context where it is used.  SQLSTATE=42703
> ).
> ANR2940E The command 'select filespaces.node_name from FILESPACEVIEW ' 
> contains
> an unknown SQL column name.
> ANS8001I Return code 3.
>
> I need it in order to select from 2 tables : select ……. From filespaces,nodes
>
> Thank you,
>   Hana
> _____________________________________________
>
> Hana Shparber (Darzi)
> Computation Center, Ben-Gurion University
> Email: hanad AT bgu.ac DOT il<mailto:hanad AT bgu.ac DOT il>
> Phone: 972-8-6461160, Mobile: 972-52-6839378
> _____________________________________________
>