Réf. : Re: Réf. : Re: Select statement (using events table)

I get nothing, as in

ANR2034E SELECT: No match found using this criteria.
ANS8001I Return code 11.

I don't get it... I should have all the shceduled backups for yesterday. I've 
tried and tried to come up with a SQL query that would enable me to format the 
ouput of a q
ev * * the way I want it (without long node names wrapping) but nothing seems 
to work...

Guillaume Gilbert
CGI Canada




Zlatko Krastev/ACIT <acit AT ATTGLOBAL DOT NET>@VM.MARIST.EDU> on 2002-06-07 
10:58:30

Veuillez répondre à "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

Envoyé par :   "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


Pour :    ADSM-L AT VM.MARIST DOT EDU
cc :
Objet :   Re:         Réf. : Re: Select statement (using events table)
Why it does not work? What error is returned and if it complains for
Why it does not work? What error is returned and if it complains for
syntax at which word?
To be sure it works I've tested it on TSM 3.7.0 for Win (being at customer
site) but when I return to office I will test it on 4.1.4.1 for AIX (out
test one) and on 4.2.1.15.

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:        Réf. : Re: Select statement (using events table)

I can't seem to get a handle on this events table. The SQL you supplied
isn't working on my server (4.1.3.0 on AIX). When I do a select with no
dates in the where clause,
all I get is the admin scheds for the current day. Other than that, I
can't get a thing. Is there something I'm missing??

Thanks

Guillaume Gilbert
CGI Canada




Zlatko Krastev/ACIT <acit AT ATTGLOBAL DOT NET>@VM.MARIST.EDU> on 2002-06-07
08:54:26

Veuillez répondre à "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

Envoyé par :   "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


Pour :    ADSM-L AT VM.MARIST DOT EDU
cc :
Objet :   Re: Select statement (using events table)

select schedule_name, status, result, reason -
from events -
where date(scheduled_start) <= current_date - cast(1 as interval day)

Zlatko Krastev
IT Consultant




Please respond to <r.harderwijk AT factotum DOT nl>
To:     "'Zlatko Krastev/ACIT'" <acit AT attglobal DOT net>
cc:

Subject:        RE: Select statement (using events table)

Hi Zlatko,

So that's the trick...

I've trying to get the startdate set, using some example statements, but I
cannot get it done it seems. Here's what I tried:

select schedule_name,status,result,reason from events where
(scheduled_start - 1 day)

Well, that doesn't work :-( (obviously because the syntax isn't right :-)
).
).
Do you happen to know how that works?

Kind regards,

Rick