Places a transfer in the suspended state. Replication Option
    does not attempt to execute the transfer until you remove it from
    the suspended state using the START TRANSFER statement. If the
    transfer is in the active state, the STOP TRANSFER statement also
    stops the copy process associated with that transfer.

1  –  Format

  (B)0STOP TRANSFER qqqqqqq> transfer-name qqqqq>

1.1  –  transfer-name

    The transfer to be suspended. The transfer-name parameter is
    required.

2  –  More

    If you want to stop a particular transfer, the transfer
    definition must be associated with your UIC, or you must
    have ALTER or DROP transfer privilege, or the OpenVMS BYPASS
    privilege.

    You must terminate any outstanding transactions before you issue
    a STOP TRANSFER statement.

    If you want to stop a particular transfer, the transfer
    definition must be associated with your UIC.

    A transfer cannot occur until you remove it from the suspended
    state using the START TRANSFER statement. If the transfer is in
    the active state, the STOP TRANSFER statement also stops the copy
    process associated with that transfer. After you stop a currently
    executing extraction, extraction rollup, or initial replication
    transfer, you cannot access the partially created target database
    unless you restart the transfer.

    If a replication update transfer is executing and you stop the
    transfer, users of the target database can continue their work
    unaffected. Furthermore, stopping the transfer does not stop
    the capture of the changes in the source database (written to
    RDB$CHANGES). The changes are transferred to the target database
    when the transfer is restarted. No updates to the target database
    are missed as a result of stopping a replication transfer for
    which the target relations have already been created. However,
    since stopping a transfer does not stop the capture of record
    changes, changes continue to be written to RDB$CHANGES regardless
    of a transfer's state. Records are added to RDB$CHANGES even
    for transfers that are suspended for a long time. The number of
    records in RDB$CHANGES and the overall size of the database both
    continue to grow.

3  –  Example

    The following example places the EUROPE_PERS transfer in the
    suspended state.

    RDO> STOP TRANSFER EUROPE_PERS