2.113 GETREPLICATES | IGNOREREPLICATES

Valid for

Extract

Description

Use GETREPLICATES or IGNOREREPLICATES to include or exclude records created by Replicat. GETREPLICATES remains in effect until IGNOREREPLICATES is entered. Once entered, IGNOREREPLICATES remains in effect until GETREPLICATES is entered.

Use IGNOREREPLICATES when two files are delivering different data to each other. For example, assume A replicates to B and B replicates to A. When A sends an insert record to B, Extract detects the replicated record and extracts it from B. In turn, Replicat replicates it back to A, which produces an error (duplicate record). Specify IGNOREREPLICATES to discard the replicated record.

GETREPLICATES can cascade replication through a chain of files. For example, if A replicates to B, and B replicates to C, IGNOREREPLICATES would prevent data from A being replicated at C. GETREPLICATES enables this to happen.

Even with GETREPLICATES set, you can avoid delivering back to the source by using WHERE or FILTER clauses in Extract or Replicat.

See "GETAPPLOPS | IGNOREAPPLOPS" for information on using GETAPPLOPS and IGNOREAPPLOPS to include or exclude records not created by Replicat.

Default

IGNOREREPLICATES

Syntax

GETREPLICATES | IGNOREREPLICATES