FROM/TO subcommand options

The FROM/TO subcommand options specify the range of record timestamps.

Usage

These subcommand options are used to specify the range of record timestamps that OMEGAMON for Db2 PE processes.

These options are used with the GLOBAL command and the FILE, REDUCE, REPORT, and TRACE subcommands.

Usage notes

If used with GLOBAL, all records outside those dates and times are discarded by OMEGAMON for Db2 PE before the remaining records are processed by other commands in the same JCL command stream. For more information about the GLOBAL command, see The GLOBAL command.
You can specify a time adjustment for a Db2 location by using the TIMEZONE option of the GLOBAL command. The time adjustment is applied to record timestamps before other time-related processing is applied.
You have several choices to specify a time frame. However, you can specify only one time frame with a subcommand.
- FROM specifies the starting date and time. Records are processed beginning with the first record having a timestamp greater than, or equal to, the FROM date and time. FROM accepts date and time specifications, in any combination, as absolute values. Without delimiting TO option, all further records in the input data set are processed.
- TO specifies the finishing date and time. Records are processed ending with the last record having a timestamp less than the TO date and time. TO accepts date and time specifications, in any combination, as absolute values. Without delimiting FROM option, processing begins with the first record in the input data set.
- FROM and TO specify the starting date and time and the finishing date and time.

Syntax

FROM/TO block

Date & Time

Parameters

date

The date in the form mm/dd/yy, where mm is the month, dd is the day, and yy is the year. For example, 25 February 2008 is entered as 02/25/08.

OMEGAMON for Db2 PE assumes that the year value (yy) lies between the system-defined date minus 95 years and the system-defined date plus four years.

You can change the way dates are specified by using DATEFORMAT. For more information, see DATEFORMAT subcommand option.

time

The time in the form hh:mm:ss.th, where hh is the hour in 24-hour format, mm is the minute, ss is the second, and th is tenths and hundredths of a second. Trailing zeros can be omitted.

Rules

The date and time variables can be used in various combinations and can also inherit values specified with the GLOBAL command.The table below describes the assumed defaults if either of the options or values is not explicitly specified.

Table 1. Option defaults for date and time variablesw
Subcommand option	Default
`FROM(date,time) TO(,time)`	If the TO date is not specified, the FROM date is assumed.
`FROM(,time) TO(date,time)`	IF the FROM date is not specified, the TO date is assumed.
`FROM(date) TO(date)`	If the FROM time is not specified, 00:00:00.00 is assumed. If the TO time is not specified, 23:59:59.99 is assumed.
`FROM(,time) TO(,time)`	If dates are not specified, all records that comply with the times are processed; the date of records are ignored. `REQUESTED ALL DATES` is printed on reports and traces in place of `REQUESTED FROM`.
`FROM(,time)`	If only the FROM time is specified, 23:59:59.99 is used for the TO time. All records with a timestamp between the FROM time and 23:59:59.99 are processed; the dates of records are ignored. `REQUESTED ALL DATES` is printed on reports and traces in place of `REQUESTED FROM`.
`TO(,time)`	If only the TO time is specified, 00:00:00.00 is used for the FROM time. All records with a timestamp between 00:00:00.00 and the TO time are processed; the dates of records are ignored. `REQUESTED ALL DATES` is printed on reports and traces in place of `REQUESTED FROM`.
`FROM(date,time)` or `FROM(date)`	If the TO date and time is not specified: For all subcommands, the TO values specified in GLOBAL are applied. If no TO values are specified in GLOBAL, processing begins with the first record with a timestamp after the FROM time (if specified) or 00:00:00.00 (if not specified), and ends with the last available record. `NOT SPECIFIED` is printed on reports and traces in place of `REQUESTED TO`.
`TO(date,time)` or `TO(date)`	If the FROM date and time is not specified: For all subcommands, the FROM values specified in GLOBAL are applied. If no FROM values are specified in GLOBAL, processing begins with the first available record, and ends with the last record with a timestamp before the TO time (if specified) or 23:59:59.99 (if not specified) on the TO date. `NOT SPECIFIED` is printed on reports and traces in place of `REQUESTED FROM`.

Example using FROM/TO: Specifying a fixed time frame

Processing starts with the first record with a timestamp after 10:00 on 25 February 2008, and ends with the last record with a timestamp before 10:10 on the same day.

 
FROM(02/25/08,10:00),TO(,10:10)

Example using FROM/TO: Specifying a fixed time interval per day

All records with a timestamp at or after 10:00 and before 10:10 are processed, regardless of the date.

 
FROM(,10:00)
TO  (,10:10)

Example using FROM/TO: Specifying a particular start time

Processing starts with the first record with a timestamp after 13:00 on 25 February 2008, and ends with the last record in the input data set.

 
FROM(02/25/08,13:00)