The Sybase Replication Agent transaction log table (ra_tran_log_) contains a column that identifies when a particular operation has occurred.
The following sample queries can help identify how these tables can be used to count the number of operations not yet processed by the Replication Agent:
For an Informix database:
select count(*) from ra_tran_log_ where process_seq < 1
For a Microsoft SQL Server database:
select count(*) from ra_tran_log_ (NOLOCK) WHERE tran_id NOT IN (SELECT ra_id FROM ra_proc_seq_ (NOLOCK))
