I would like to use the select command, since it allows me to manipulate the column location, and the heading.
Michael Moore VF Services Inc. Yahya Ilyas <Yahya.Ilyas@ASU. To: [EMAIL PROTECTED] EDU> cc: Sent by: "ADSM: Subject: Re: Help with select Dist Stor Manager" <[EMAIL PROTECTED] .EDU> 10/16/02 11:36 AM Please respond to "ADSM: Dist Stor Manager" You can try following: query event * schedulename begindate=-1 enddate=today (query event domainname schedulename) ----- Yahya Ilyas Systems Programmer Sr Systems Integration & Management Information Technology Arizona State University, Tempe, AZ 85287-0101 -----Original Message----- From: Michael Moore [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 16, 2002 7:20 AM To: [EMAIL PROTECTED] 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