Paul,

You are correct. the design of the SELECT * FROM EVENTS was intended
to present only events for today (just like QUERY EVENTS). However,
I agree that the design ought to be changed to reflect the SQL
standard: that is, SELECT * FROM <anytable> presents *all* records
in that table, not just certain ones. In the case of QUERY EVENTS,
you can query events as far back as you want, but the status may
be "uncertain" if the events go back further than your event record
retention setting. So in my opinion, SELECT * FROM EVENTS should
show you all events that are available within the event record
retention timeframe.

This is a change I am lobbying for with the server developers.

Regards,

Andy

Andy Raibeck
IBM/Tivoli
Tivoli Storage Manager Client Development
e-mail: andrew.raibeck AT tivoli DOT com
"The only dumb question is the one that goes unasked."

Hello,

Can anyone explain the following results to me?

tsm: TEST>select count(*) from events

Unnamed[1]
-----------
        117
        117

tsm: TEST>select count(*) from events where '08/01/2000' < scheduled_st
                   art

Unnamed[1]
-----------
       8507
       8507


It seems as if by narrowing down my selection I get more results. This seems
to be behaving like a Q EVENTS rather than SQL.


Confused of Frankfurt.


_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at
http://profiles.msn.com.