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: [email protected]<mailto:[email protected]> > Phone: 972-8-6461160, Mobile: 972-52-6839378 > _____________________________________________ -- Met vriendelijke groeten/Kind Regards, Remco Post [email protected] +31 6 248 21 622
