Re: SELECT STATEMENT NOT WORKING

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