ttRepXactTokenGet

This procedure 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 run 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.

Related Views

This procedure has no related views.

Syntax

ttRepXactTokenGet('typ')

Parameters

ttRepXactTokenGet has these parameters:

Parameter Type Description

typ

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.