ttRepXactTokenGet

Description

Returns a token for RETURN RECEIPT or RETURN TWOSAFE replication transactions. Depending on the input parameter, type, it returns either:

A token to the most recently committed RETURN RECEIPT transaction on the connection handle in which it is invoked.
A token to the most recent transaction on the connection handle in which it is invoked that has begun commit processing on a transaction in RETURN TWOSAFE mode.

This procedure can be executed in any subsequent transaction or in the same transaction after commit processing has begun for a transaction in RETURN TWOSAFE replication.

Required privilege

This procedure requires no privilege.

Syntax

ttRepXactTokenGet('type')

Parameters

ttRepXactTokenGet has these parameters:

Parameter Type Description

Parameter	Type	Description
`type`	TT_CHAR (2) NOT NULL	The type of transaction desired: `'RR'` -- Return receipt. `'R2'` -- Return twosafe.

type

TT_CHAR (2) NOT NULL

The type of transaction desired:

'RR' -- Return receipt.

'R2' -- Return twosafe.

Result set

ttRepXactTokenGet returns the result set:

Column	Type	Description
`token`	VARBINARY (10000)	A varbinary token used to represent the transaction desired.