Valid for

Extract, Replicat

Description

Use BEGIN to specify a date and time at which to start capturing data. Any record with a timestamp greater than or equal to the time specified by BEGIN that satisfies other criteria is extracted.

SPECIALRUN uses BEGIN to determine its start date and time.

Syntax

BEGIN date time[:seconds][.centiseconds]

date

The date in yyyy-mm-dd format.

time

The time in hh:mm format.

seconds

You can optionally specify seconds with the time option, as in hh:mm:ss.

centiseconds

You can optionally specify centiseconds seconds with the time and seconds options, as in hh:mm:ss.cccccc.

Examples

Example 1   

BEGIN 2010-08-12 08:00 specifies a timestamp for August 12, 2010 at 8:00 AM.

Example 2   

BEGIN 2010-08-12 08:00:30.000030 specifies a timestamp for August 12, 2010 at 8:00:30.000030 AM.