ttRepTransmitSet

This procedure stops subsequent updates on the connection it is run in from being replicated to any subscriber. Use this procedure 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.

Usage in TimesTen Scaleout and TimesTen Classic

This procedure is supported in TimesTen Classic but not supported in TimesTen Scaleout.

Related Views

This procedure has no related views.

Syntax

ttRepTransmitSet(transmit)

Parameters

ttRepTransmitSet has the parameter:

Parameter Type Description

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 run. (This is the default.) When set to 0, updates are not transmitted to any subscribers for the remainder of the transaction in which this call was issued on the connection that issued it.

transmit

TT_INTEGER NOT NULL

When set to 1, updates are transmitted to subscribers on the connection after the built-in is run. (This is the default.)

When set to 0, updates are not transmitted to any subscribers for the remainder of the transaction in which this call was issued on the connection that issued it.

Result Set

ttRepTransmitSet returns no results.

Examples

To activate the active database in an active standby pair, use:

CALL ttRepTransmitSet(1);

To deactivate the active database in an active standby pair, use:

CALL ttRepTransmitSet(0);