On 14 feb 2010, at 15:33, Hana Darzi wrote:

> Hello all,
> 
> Why this query do not work in tsm 6.1.3.1 ?
> 

Hana,

have you tried using:

select node_name from filespaces

as a work-around? As you see from the error, there is an underlaying view in 
DB2. It's not unlikely that you have found a bug in TSM, so please also report 
this one to IBM.


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

-- 
Met vriendelijke groeten/Kind Regards,

Remco Post
r.post AT plcs DOT nl
+31 6 248 21 622