ttRepSyncGet
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
ttRepSyncGet()
Parameters
ttRepSyncGet
has no parameters.
Result Set
ttRepSyncGet
returns the result set:
Column | Type | Description |
---|---|---|
|
|
|
|
|
Specifies the number of seconds to wait for return service acknowledgment. The default value is 10 seconds. A value of `0' means that there is no wait time.This attribute persists across transaction boundaries and applies to all |
|
|
The current
|
Examples
To retrieve the caller's requestReturn
value, use:
SQLCHAR requestReturn[1]; SQLINTEGER len; rc = SQLExecDirect ( hstmt , (SQLCHAR *) "{CALL ttRepSyncGet( NULL )}" , SQL_NTS ) rc = SQLBindCol ( hstmt , /* ColumnNumber */ 1 , /* Tarype */ SQL_C_BINARY ) , /* TargetValuePtr */ requestReturn ,./* BufferLength */ sizeof requestReturn , /* StrLen_ */ &len ); rc = SQLFetch( hstmt ); if ( requestReturn[0] ) { ... }
Notes
-
When called within a standalone transaction,
ttRepSyncGet
always returns the default value forrequestReturn
. -
Applications can call
ttRepSyncGet
at any point within a transaction in which it is used to request theBY REQUEST
return service for that transaction. -
If you call
ttRepSyncGet
in a transaction that does not update anyRETURN RECEIPT BY REQUEST
orRETURN TWOSAFE BY REQUEST
replication elements, the call has no external effect.
See Also
- ttRepDeactivate
- ttRepTransmitSet
- ttReplicationStatus
- ttRepPolicySet
- ttRepStart
- ttRepStop
- ttRepSubscriberStateSet
- ttRepSubscriberWait
- ttRepSyncSet
- ttRepDuplicateEx in Oracle TimesTen In-Memory Database C Developer's Guide