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.
Without END, the process runs continuously until:
-
the end of the transaction log or trail is reached, at which point it will stop gracefully.
-
manually terminated from the command shell.
Use END with the SPECIALRUN parameter to post data as a point-in-time snapshot, rather than continuously updating the target tables.
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:
-
dateis a date in the format ofyyyy-mm-dd. -
timeis the time in the format ofhh: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
RUNTIMEis 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.