Thanks all. Adding the alias names fixed it.
Gary Lee Senior System Programmer Ball State University phone: 765-285-1310 -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of Thorsten Burghardt Sent: Wednesday, September 07, 2011 9:36 AM To: [email protected] Subject: [ADSM-L] Antwort: [ADSM-L] Sql query problem in tsm 6.2 Hi, use following Syntax: select ev.node_name, ev.status, no.email_address from events ev, - nodes no where ev.node_name = no.node_name and - ev.status != 'Completed' and - ev.scheduled_start> '2011-09-06 08:00:00' and - ev.scheduled_start< '2011-09-07 07:00:00' Thorsten Von: "Lee, Gary D." <[email protected]> An: [email protected] Datum: 07.09.11 15:07 Betreff: [ADSM-L] Sql query problem in tsm 6.2 Gesendet von: "ADSM: Dist Stor Manager" <[email protected]> TSM folks, tsm server 6.2.2 on redhat enterprise linux 6.0 I submit the following file as a macro and recieve the errors below. This query works in tsm 5.5 file c:\tsmscripts\pl3 ------------- select events.node_name, events.status, nodes.email_address from events, - nodes where events.node_name = nodes.node_name and - events.status != 'Completed' and - events.scheduled_start> '2011-09-06 08:00:00' and - events.scheduled_start< '2011-09-07 07:00:00' tsm screen cut below. ---------------- tsm: TSM01>macro c:\tsmscripts\pl3 ANS8000I Server command: 'select events.node_name, events.status, nodes.email_ ad dress from events, nodes where events.node_name = nodes.node_name and events.s ta tus != 'Completed' and events.scheduled_start> '2011-09-06 08:00:00' and event s. scheduled_start< '2011-09-07 07:00:00'' ANR0162W Supplemental database diagnostic information: -1:42S22:-206 ([ IBM][CLI Driver][DB2/LINUXX8664] SQL0206N "NODES.NODE_NAME" is not valid in the context where it is used. SQLSTATE=42703 ). ANR2940E The command 'select events.node_name , events.status , nodes.email_address from events , NODESVIEW where events.node_name = nodes.node_name and events.status != 'Completed' and events.scheduled_start > ' 2011-09-06 08:00:00' and events.scheduled_start < '2011-09-07 07:00:00' ' contains an unknown SQL column name. ANS8001I Return code 3. ANS8 29E Macro processing terminated. tsm: TSM01> Gary Lee Senior System Programmer Ball State University phone: 765-285-1310 +++++ 750 Jahre Knappschaft. Soziale Verantwortung zu jeder Zeit. www.750jahre.info +++++
