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
> _____________________________________________
>
|