X hits on this document

958 views

0 shares

0 downloads

0 comments

138 / 236

EDS Utility Processor

Exclude date and times (EXCLUDE command)

The EXCLUDE command allows you to exclude certain data based on the date and/or time the data was collected.

After the KEBUTIL EXCLUDE command is read from the RKEI2IN DDcard, it defines records for the dates and times to be excluded from the EPILOG datastore when the data is reloaded from the backup tape.

You can enter multiple EXCLUDE commands during a single run; the file is not copied until the end of the file is reached on RKEI2IN. No data is copied unless all the EXCLUDE commands are parsed correctly.

The following are the acceptable keywords for EXCLUDE:

Date/time

BAND/RANGE, DAYOFWK, ENDDATE, ENDTIME, LASTMONTH, LASTWEEK, NUMDAY, STARTDATE, STARTTIME, THISMONTH, THISWEEK, TODAY, YESTERDAY

For definitions of these keywords, see Figure 11 on page 75.

For example, to delete all the data for the previous month from the EDS, use the command EXCLUDE LASTMONTH.

To delete all the records from before a certain date and time, enter a command like the following:

EXCLUDE ENDDATE(01/02/97) ENDTIME(2400) This command excludes all records written prior to midnight on 01/02/97.

When specifying start and end times with the EXCLUDE command, remember that BAND is the default. Thus, if the ENDTIME on the previous command was (1200), the same command would also exclude records that were written on any date up to and including the end date (01/02/97), but only those that were written between 00:00 hours and 12:00 hours. Records written between 12:01 and 24:00 would not be excluded.

To override the BAND default, you must specify the RANGE keyword. The following command excludes all records written up to and including 12 noon on the end date (01/02/97).

EXCLUDE ENDDATE(01/02/97) ENDTIME(1200) RANGE

138

OMEGAMON II for DBCTL Historical Component (EPILOG) Reference Manual Version 510

Document info
Document views958
Page views958
Page last viewedThu Dec 08 16:30:47 UTC 2016
Pages236
Paragraphs8116
Words69808

Comments