Interpret an outboud queue containing an update transaction.
update emp_queue set emp_first = "General" where emp_id = "123456789"
sysadmin dump_queue, 103, 0, -1,1,-2
I. 2006/07/05 08:31:32. BLOCK BEGIN q_number=103 q_type=0 blk=0:3 cnt=3 I. 2006/07/05 08:31:32. Begin Transaction Origin User=sa Tran Name=_upd I. 2006/07/05 08:31:32. ENTRY ver=1100 len=204 orig=102 lorig=0 oqid=00000000000016e3000005020005000005020002 000097f5008bedfe0000000000000001 lqid=0:3:0 st=4 tr='00000000000016e30002' NYDSnydb comlen=88 begin transaction I. 2006/07/05 08:31:32. ENTRY ver=1100 len=268 orig=102 lorig=0 oqid=00000000000016e3000005020005000005020002 000097f5008bedfe0000000000000002 lqid=0:3:1 st=0 tr= '00000000000016e30002' NYDSnydb comlen=149 update emp_queue set emp_id='123456789', emp_first='General', emp_last='Davis', emp_title='Process Engineer', emp_date='1/1/95', id=1111 where id=1111 I. 2006/07/05 08:31:32. ENTRY ver=1100 len=180 orig=102 lorig=0 oqid=00000000000016e3000005020005000005020002 000097f5008bedfe0000000000000003 lqid=0:3:2 st=1 tr= '00000000000016e30002' NYDSnydb comlen=63 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.