Working one:
select node_name from events where scheduled_start>='2002-09-12'
Not working one (!!!):
select node_name from events where scheduled_start>=cast(current_date-10
days as timestamp)

It looks like when you supply where clause with constant it works. But if
you try to use calculated value it does not. In June I've posted a select
which worked on TSM v3.7 but unfortunately it does not on v4.2:
select <whatever> from events -
where date(scheduled_start) <= current_date - cast(1 as interval day)

As a workaround I was able to create the following select:
select 'select <whatever> from events where scheduled_start>=''' -
concat cast(current_date-10 days as char(10)) concat '''' as -
"*****************************************************************" -
from db
Output of this select is redirected to a file, file is processed outside
TSM (removed all but last line) and on the end is run as a TSM macro.

This is different from the behavior described in APAR IC28825. So maybe I
should open new APAR.


Zlatko Krastev
IT Consultant





Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
Sent by:        "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To:     ADSM-L AT VM.MARIST DOT EDU
cc:

Subject:        Re: how to select events?

I still can't get this to work. Could someone please provide a WORKING
example of a select command that would display all events for the last 10
days?