Automatic LOCK after REWRITE Statement

chenchi · Posted: Tue Jun 22, 2004 2:42 pm

hi to all

after executing READ/UPDATE command automically exclusive lock will be set up. and after executing REWRITE command that lock will be automatically released..so what is the need of UNLOCK command..?

gkchakri · New User Joined: 07 Jun 2004 Posts: 9 Location: Bangalore

Hai PCR,

Your ques is good, By READ/UPDATE command we are going to read a particular record and Update or Modify it. If we are REWRITING the record it implicitly locks the record. so, we need to explicitly UNLOCK it to make access to others.

BY READ/UPDATE if we are simply reading with out REWRITE command, i think there is no need of Explicitly UNLOCKING the file.

I feel, i had solved your problem to some extent....................

If any faults please let me know.,

by,
gkchakri.

VIKAS GAIKWAD · New User Joined: 30 Nov 2006 Posts: 33 Location: MUMBAI

Hi ,

Main use of UNLOCK command is .

Suppose u r using READ/UPDATE for Rewriting but some times u r not Rewriting (if condition fails or becomes true) then in such cases it is explictly requires that u use UNLOCK command.

That meance u r using READ/UPDATE but not REwriting.
In this case u have to use UNLOCK command.