ttRepTransmitSet

Description

Stops subsequent updates on the connection it is executed in from being replicated to any subscriber.

This procedure should be used with care since it could easily lead to transactional inconsistency of remote stores if partial transactions are replicated. If updates are disallowed from getting replicated, the subscriber stores diverge from the master store.

Required privilege

This procedure requires the ADMIN privilege.

Syntax

ttRepTransmitSet(transmit)

Parameters

ttRepTransmitSet has the parameter:

Parameter	Type	Description
`transmit`	TT_INTEGER NOT NULL	When set to 1 updates are transmitted to subscribers on the connection after the built-in is executed to replicate. (default) When set to 0 updates are not transmitted to any subscribers for the remainder of the transaction in which this call was issued, as well as on the connection that issued it.

Result set

ttRepTransmitSet returns no results.

Example

To activate the active data store in an active standby pair, use:

CALL ttRepTransmitSet(1);

To deactivate the active data store in an active standby pair, use:

CALL ttRepTransmitSet(0);