Joni,
Your observations are symptomatic of APARs IC28825 and IC34609. You can
find more detail about these by going to the IBM web site (www.ibm.com)
and doing a search on these APAR numbers.
You need to hard-code a value in your date criterion, although this could
be automated through the help of a script.
As a "sanity" check, try the following:
SELECT node_name, scheduled_start, schedule_name, status
FROM events
WHERE (node_name LIKE 'HMCH%' OR node_name LIKE 'HMPG%')
AND scheduled_start> '2003-03-18'
ORDER BY node_name
Also be careful with the '>' sign, as this could be interpreted as
redirection. Note how I put the '>' sign immediately to the right of the
"scheduled_start" part.
Regards,
Andy
Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.eyebm DOT com (change eye to i to reply)
The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.
Joni Moyer <joni.moyer AT HIGHMARK DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
03/20/2003 07:36
Please respond to "ADSM: Dist Stor Manager"
To: ADSM-L AT VM.MARIST DOT EDU
cc:
Subject: SELECT STATEMENT NOT WORKING
Hello,
I am really not having luck with this statement. I am receiving no
output
and I honestly thought that this command would do it. It is giving me
problems with the WHERE (node_name...) Does anyone know what I am doing
wrong? Thanks!
SELECT node_name, scheduled_start, schedule_name, status
FROM events
WHERE (node_name LIKE 'HMCH%' OR node_name LIKE 'HMPG%')
AND scheduled_start > getdate() - 1
ORDER BY node_name
Joni Moyer
Systems Programmer
joni.moyer AT highmark DOT com
(717)975-8338
|