Re: select statement syntax

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:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Joni Moyer
Sent: Friday, October 03, 2003 10:04 AM
To: ADSM-L AT VM.MARIST DOT EDU
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
joni.moyer AT highmark DOT com
(717)975-8338