select statement syntax
2003-10-03 11:29:03
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
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- select statement syntax,
Joni Moyer <=
|
|
|