Contents Index sr_queue_state table sr_confirmed_transaction table

SQL Remote User's Guide
  System Objects for Adaptive Server Enterprise
    Stable Queue tables

sr_transaction table


Function 

This table has one row for each transaction in the stable queue.

Columns 
Column Description
offset The transaction log offset of the commit operation for the transaction. This value uniquely identifies each transaction
user_id The remote user where the transaction originated. This column holds NULL if the transaction did not originate from a remote user.

The user_id column is used to ensure that actions are not replicated back to the remote site that entered them.

data The transaction itself, in an internal representation.

Contents Index sr_queue_state table sr_confirmed_transaction table