Begin Tran and Flock()

Begin Tran and Flock()

Post by TWlrZ » Sat, 21 Feb 2004 21:56:06


Hi,
Do I need to Flock before Begin Trans. or it will be locked auto by begin trans. and if I am doing flock(), do I need to give Unlock command to unlock, or End Tran / Rollback will unlock them automatically ?

Thanks,

Mike
 
 
 

Begin Tran and Flock()

Post by Christian » Sat, 21 Feb 2004 22:13:55

Hello,

you don't ..
any locks implicitly made between BEGIN Tran and END Tran/Rollback are
automatically released by END Tran/Rollback ..

also ..the table header is only locked by an INSERT statement .. an UPDATE
statement would only lock individual records (RLOCK())

Regards

Christian

"Mike" < XXXX@XXXXX.COM > schrieb im Newsbeitrag

trans. and if I am doing flock(), do I need to give Unlock command to
unlock, or End Tran / Rollback will unlock them automatically ?