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 _____________________________________________
