Try using the BETWEEN for the where clause. I saw that the TSM Operations Reporting package uses this:
select node_name, scheduled_start, schedule_name, status - from events - where (node_name like 'HM%' or node_name like 'PA%') - and scheduled_start between current_timestamp - 1 day and current_timestamp - order by node_name I just tried this on my TSM system (tsm 5.1.7.1 on AIX): tsm: TSM>select node_name,scheduled_start,schedule_name,status from events where scheduled_start between current_timestamp-1 day and current_timestamp and (node_name like 'LDS%') Bil Boyer DSS, Inc. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Joni Moyer Sent: Friday, October 03, 2003 10:04 AM To: [EMAIL PROTECTED] Subject: select statement syntax Hello everyone! I have tried this select statement many times with no success. I thought that this statement had previously worked, but now I'm having problems again... I am looking for all nodes that begin with HM and PA for the past day. Does anyone have any suggestions? This is on a mainframe TSM server 5.1.6.2 and I am trying to query NT clients. I have also tried to create this through the TSM Opertional Reporting tool without any luck, so I am assuming that something is wrong with my syntax. Thanks in advance!!! select node_name, scheduled_start, schedule_name, status - from events - where (node_name like 'HM%' or node_name like 'PA%') - and scheduled_start>current_timestamp - 1 day - order by node_name Joni Moyer Systems Programmer [EMAIL PROTECTED] (717)975-8338
