Previous Topic: Input Control Statement DescriptionsNext Topic: Estimate the Space Requirements for the Data Mart Output Data Sets


Sample Input control Statement Commands

The following examples show how to capture data on a specific date, daily basis, and in a specific time period.

Use the following example when capturing data on a specific date. For example, if today's date is 6/21/11, the following captures data from 12:00:00:01 a.m. on 6/21/11 to 11:59:59:99 p.m.

logstream(logstreamname)
SDATE(6/21/2011)
EDATE(6/21/2011)

Use the following example to automatically capture data on a daily basis. For example, if today's date is 6/21/2011, the following captures data today from 12:00:00:01 a.m. to 11:59:59:99 p.m. No specific date is required in this example.

logstream(logstreamname)
SDATE(TODAY)
EDATE(TODAY)

Use the following example to automatically capture data for the prior day. For example, if today's date is 6/21/2011, the following captures data from 12:00:00:01 a.m. to 11:59:59:99 p.m. on 6/20/2011. No specific date is required in this example.

logstream(logstreamname)
SDATE(TODAY-1)
EDATE(TODAY-1)

If you wish to capture data 20 days in the past from yesterday's date, indicate the following:

logstream(logstreamname)
SDATE(TODAY-20)
EDATE(TODAY-1)

Use the following example to automatically capture data in an 8-hour period of time. For example, if today's date is 6/21/2011, the following captures data today from 8:00 a.m. to 4:00 p.m.

logstream(logstreamname)
SDATE(TODAY)
STIME(08:00:00:00)
EDATE(TODAY)
ETIME(16:00:00:00)