For some reason 6.2 does not like linking tables in the old way. You need to use aliases.
Try this select statement: select ev.node_name, ev.status, nd.email_address from events ev, nodes nd where ev.node_name = nd.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' Dan Fiske -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Lee, Gary D. Sent: Wednesday, September 07, 2011 9:02 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Sql query problem in tsm 6.2 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