Thank you. I tried and it works. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of Dmitry Sent: Sunday, February 14, 2010 4:57 PM To: [email protected] 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: [email protected]<mailto:[email protected]> > Phone: 972-8-6461160, Mobile: 972-52-6839378 > _____________________________________________ >
