Re: Help with select
2002-10-16 19:17:04
Select from events tables does not work if you have a calculated timestamp
or date in where clause. If you use "where scheduled_start>='10/15/2002' "
it will work.
Zlatko Krastev
IT Consultant
Michael Moore <Michael_Moore AT VFC DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
16.10.2002 17:20
Please respond to "ADSM: Dist Stor Manager"
To: ADSM-L AT VM.MARIST DOT EDU
cc:
Subject: Help with select
I am trying to setup some reporting on events on the server. Here is what
I see:
If I do a 'Q EVENTS * * BEGINDATE=TODAY-1 ENDDATE=TODAY-1' I get the
following:
Scheduled Start Actual Start Schedule Name Node Name
Status
-------------------- -------------------- ------------- -------------
---------
10/15/2002 12:17:42 TEST_DAILY_1- 02LC0
Missed
800
10/15/2002 12:17:42 TEST_DAILY_1- MANAGE_ME
Missed
800
10/15/2002 16:27:00 10/15/2002 16:28:02 SRV_DAILY_FI- ITGC2AFILER
Completed
LER
10/15/2002 16:58:00 10/15/2002 17:03:54 SRV_DR_DAILY- ITGC2A01
Failed
_1730
10/15/2002 16:58:00 10/15/2002 17:03:54 SRV_DR_DAILY- ITGC2AS1
Completed
_1730
10/15/2002 16:58:00 10/15/2002 17:03:52 SRV_DR_DAILY- ITGC2AARTHUR4
Completed
_1730
10/15/2002 16:58:00 SRV_DR_DAILY- ITGC2APRODTR-
Missed
_1730 AN
10/15/2002 16:58:00 10/15/2002 17:03:51 SRV_DR_DAILY- ITGC2ARFSM
Completed
But, if I do a 'select * from events where schedule_name
='SRV_DR_DAILY_1730' and date(scheduled_start)> current date -2 days' I
get the following:
ANR2034E SELECT: No match found using this criteria.
ANS8001I Return code 11.
Thanks for any help someone can provide!
Oh, by the way, I am running v4.2.2.12 on OS/390 v2.10
Michael Moore
VF Services Inc.
121 Smith Street
Greensboro, NC 27420-1488
Voice: 336-332-4423
Fax: 336-332-4544
|
|
|