RDOHELP72.HLB  —  Replication Option, DEFINE_TRANSFER, Format  EXTRACTION_ROLLUP
    Specifies that Replication Option create an extraction rollup
    database at the target site by transferring selected relations
    and fields from one or more source databases into a single
    target database. An extraction rollup database is created at the
    target site, and Replication Option reads data from the source
    databases and stores the data in a target database.

    Each time an extraction rollup transfer is executed, Replication
    Option creates a new version of the target database and
    transfers to it a complete copy of the selected records.

    The EXTRACTION ROLLUP option in the DEFINE TRANSFER statement has
    the following characteristics and limitations:

    o  Replication Option issues an error message if you do not
       enter a MOVE RELATION clause or a SELECT FIELDS list in a
       move-relations-rollup-clause.

    o  You must refer to each source database in the DEFINE TRANSFER
       statement by its database handle.

    o  On the target database, relation names and field names must
       be unique. Consequently, all target relations of the same name
       must have the same definition, and all target fields of the
       same name must have the same data type. If the definitions
       or data types differ, Replication Option issues an error
       message and the transfer fails.

    o  If any database specified in the transfer definition is on a
       node that is not available, Replication Option places the
       transfer in a waiting-to-retry state. Replication Option
       will retry the transfer at the time specified for retry in the
       schedule definition.

    o  If any of the source nodes specified in the transfer
       definition fail during the transfer, the transfer will also
       fail. Replication Option will retry the transfer at the time
       specified for retry in the schedule definition.

    o  If the transfer fails, the retry will start at the beginning,
       not where the transfer left off.

    Indexes, constraints, and access rights are not transferred
    when the target database is created. Similarly, primary key
    and foreign key attributes for a particular relation are
    not transferred because key attributes are implemented as
    constraints. Once the target database has been created, you can
    define indexes, constraints, and triggers for it and modify the
    access rights.
Close Help