2.57 END

Valid for

Extract, Replicat

Description

Use END to specify the point at which the process stops processing in the TMF audit or Oracle GoldenGate trails. If END is omitted, processing continues until you stop it manually with GGSCI.

With END, processing terminates when an audit record is encountered with a timestamp equal to or greater than the time specified. You can specify the day, the time of day, including seconds and centiseconds as in: END 2010-08-12 17:00:00.

END is used to determine when SPECIALRUN processing will terminate.

Syntax

END {date [time] | RUNTIME}

date time

Causes Extract or Replicat to terminate when it encounters a record with a timestamp equal to, or greater than, the time specified.

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 Extract or Replicat to terminate when it reaches process startup time. 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.