ttRepSyncGet

Description

Returns static attributes associated with the caller's use of the replication- based return service. This procedure operates with either the RETURN RECEIPT or RETURN TWOSAFE service.

Required privilege

This procedure requires no privilege.

Syntax

ttRepSyncGet()

Parameters

ttRepSyncGet has no parameters.

Result set

ttRepSyncGet returns the result set:

Column Type Description

Column	Type	Description
`requestReturn`	BINARY(1)	0 - Don't wait for return notification configured with the RETURN RECEIPT BY REQUEST or RETURN TWOSAFE BY REQUEST option; this value is the default. 1 - Wait for the return notification. Commit resets this attribute to its default value of 0 ("off").
`returnWait`	TT_INTEGER	Specifies the number of seconds to wait for return service acknowledgement. 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 RETURN services independent of the BY REQUEST option.
`localAction`	TT_INTEGER	The current LOCAL ACTION configuration for RETURN services. `NO ACTION` -- When a COMMIT times out, it returns the application unblocked, leaving the transaction in the same state it was when the COMMIT began, with the exception that the application is not able to update any replicated tables. The application may only reissue the COMMIT. This is the default. `COMMIT` -- When the COMMIT times out, the transaction is committed locally. No more operations are possible on this transaction, and the replicated data stores diverge.This attribute persists across transactions and for the life of the connection.

requestReturn

BINARY(1)

0 - Don't wait for return notification configured with the RETURN RECEIPT BY REQUEST or RETURN TWOSAFE BY REQUEST option; this value is the default.

1 - Wait for the return notification. Commit resets this attribute to its default value of 0 ("off").

returnWait TT_INTEGER Specifies the number of seconds to wait for return service acknowledgement. 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 RETURN services independent of the BY REQUEST option.

localAction

TT_INTEGER

The current LOCAL ACTION configuration for RETURN services.

NO ACTION -- When a COMMIT times out, it returns the application unblocked, leaving the transaction in the same state it was when the COMMIT began, with the exception that the application is not able to update any replicated tables. The application may only reissue the COMMIT. This is the default.

COMMIT -- When the COMMIT times out, the transaction is committed locally. No more operations are possible on this transaction, and the replicated data stores diverge.This attribute persists across transactions and for the life of the connection.

Example

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
                , /* TargetType */      SQL_C_BINARY )
                , /* TargetValuePtr */     requestReturn
                ,./* BufferLength */      sizeof requestReturn
                , /* StrLen_ */         &len );
rc = SQLFetch( hstmt );
if ( requestReturn[0] ) {
...
}

Note

When called within a stand-alone transaction, ttRepSyncGet always returns the default value for requestReturn.

ttRepSyncGet may be called at any point within a transaction in which it is used to request the BY REQUEST return service for that transaction.

If you call ttRepSyncGet in a transaction that does not, in fact, update any RETURN RECEIPT BY REQUEST or RETURN TWOSAFE BY REQUEST replication elements, the call has no external effect.