The Replicate function eliminates the need to map individual Source to Target fields and columns when the Source and Target datastores are physically identical. the Apply Engine supports replication of IMS hierarchical databases, VSAM files and Relational databases. Because of the obvious structure clash between these three principal types of datastores, they cannot be automatically replicated between each other. Because of their inherent similarity, the Apply Engine will perform heterogeneous replication of a Relational Database, i.e. from DB2 to Oracle, Oracle to MS SQL Server or any other combination of the supported Relational database management systems (RDBMS).
Besides the obvious benefit of not having to manually map Source to Target fields, the Replication function provides significantly increase CPU performance as far less overhead is required when access to source and target data for validation, criteria evaluation or transformation is not needed.
- Source and Target Datastores, depending on their type must have matching Segment, Record or Table Names.
- Field or Column names do not have to match but the sequence of field or columns in the Source and Target Descriptions must match.
- Field or column types must be "compatible"
- If KEY IS is not specified for the Target datastore, the Key must be available in the database catalog.
Syntax
REPLICATE <target_datastore>
| Keyword | Description |
|---|---|
| <target_datastore> | Specifies the name of the Target Datastore which may be "described by" either an individual or Group Target Description. |