ADSM-L

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

2002-06-07 11:01:07
Subject: Re: Réf. : Re: Select statement (using events table)
From: Zlatko Krastev/ACIT <acit AT ATTGLOBAL DOT NET>
Date: Fri, 7 Jun 2002 17:58:30 +0300
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



<Prev in Thread] Current Thread [Next in Thread>