END

Valid For

Replicat

Description

Use the END parameter to terminate Replicat when it encounters the first record in the data source whose timestamp is the specified point in time.

You can only use END with the SPECIALRUN parameter. This parameter allows you to post data as a point-in-time snapshot, rather than continuously updating the target tables.

Without END, the process runs continuously until:

• the end of the trail is reached, at which point it will stop gracefully.

• manually terminated from the command shell.

Default

Continuous processing

Syntax

END {date [time] | RUNTIME}

date [time]

Causes Replicat to terminate when it reaches a record in the data source whose timestamp exceeds the one that is specified with this parameter.

Valid values:

• date is a date in the format of yyyy-mm-dd.

• time is the time in the format of hh:mi[:ss[.cccccc]] based on a 24-hour clock.

RUNTIME

Causes Replicat to terminate when it reaches a record in the data source whose timestamp exceeds the current date and clock time. All unprocessed records with timestamps up to this point in time are processed. One advantage of using RUNTIME is that you do not have to alter the parameter file to change dates and times from run to run. Instead, you can control the process start time within your batch programming.

Examples

Example 1

SPECIALRUN
END 2010-12-31 17:00:00

Example 2

SPECIALRUN
END RUNTIME