Hana, This is correct request

--

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
_____________________________________________