ttRepSyncSet
RETURN RECEIPT
or RETURN TWOSAFE
service.
Required Privilege
This procedure requires no 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
ttRepSyncSet([requestReturn], [returnWait], [localAction])
Parameters
ttRepSyncSet
has these optional parameters:
Parameter | Type | Description |
---|---|---|
|
|
You can use this parameter to turn on or turn off return services only when the replication subscribers have been configured with |
|
|
Specifies the number of seconds to wait for return service acknowledgment. The default value is This timeout value overrides the value set by the The timeout set by this parameter persists across transaction boundaries and applies to all return services independent of the |
|
|
Action to be performed in the event the subscriber cannot acknowledge commit of the transaction within the timeout period specified by
|
Result Set
ttRepSyncSet
has no result set.
Examples
To enable the return receipt service in the current transaction for all the replication elements configured with RETURN RECEIPT BY REQUEST
or RETURN TWOSAFE BY REQUEST
, use:
rc = SQLExecDirect ( hstmt, (SQLCHAR *)"{CALL ttRepSyncSet( 0x01 )}", SQL_NTS )
Note:
The call to enable the return receipt service must be part of the transaction (AutoCommit
must be off).
See Also
- ttRepDeactivate
- ttRepTransmitSet
- ttReplicationStatus
- ttRepPolicySet
- ttRepStart
- ttRepStop
- ttRepSubscriberStateSet
- ttRepSubscriberWait
- ttRepSyncGet
- ttRepDuplicateEx in Oracle TimesTen In-Memory Database C Developer's Guide