In this example, an update has been performed at the primary database. The minimal column feature has not been set for the replication definition:
update emp_queue set emp_first = "General" where emp_id = "123456789"
To view the outbound queue or the replicate:
sysadmin dump_queue, 103, 0, -1,1,-2
BLOCK BEGIN q_number=103 q_type=0 blk=0:21 cnt=3
I. 95/06/28 16:42:37. Begin Transaction Origin User=sa Tran Name=upd
I. 95/06/28 16:42:37. ENTRY len=184 orig=102 oqid=0000000100000a670000028f0007ffffffff00000000883c01131c100001000000000001 lqid=0:21:0 st=4 tr= '0000000100000a' g '0002' NYDSnydb comlen=71 begin transaction upd
I. 95/06/28 16:42:37. ENTRY len=328 orig=102 oqid=0000000100000a670000028f0007ffffffff00000000883c01131c100001000000000002 lqid=0:21:1 st=0 tr= '0000000100000a' g '0002' NYDSnydb comlen=216 update emp_queue set emp_id='123456789',emp_last='Davis ',emp_first='General ',emp_title='Process Engineer ',emp_date='Jan 1 1995 12:00:00:000AM',branch_id=1111 where emp_id='123456789'
I. 95/06/28 16:42:37. ENTRY len=168 orig=102 oqid=0000000100000a670000028f0007ffffffff00000000883c01131c100001000000000003 lqid=0:21:2 st=1 tr= '0000000100000a' g '0002' NYDSnydb comlen=55 commit transaction
cnt=3
There are 3 rows in this block.
Tran Name=upd
If you perform an update and did not explicitly start a transaction, Adaptive Server uses upd as the transaction name. Likewise, Adaptive Server uses del for a delete command and ins for an insert command.
st=4, st=0, st=1
Status for begin, other, and commit.
