Record Lock in Subfile
Home > IT Answers > AS/400 > Record Lock in Subfile
Vipin2m
45 pts.
0
Q:
Record Lock in Subfile
AS/400 Display File, AS/400 Subfiles
Hi all,

I am trying to find any keyword which is used to lock the record in Subfile. Please find the scenario:

Let assume two users are trying to read the same record on the subfile from different session. Now when the 2nd user was trying to read any record while 1st user is using same record from different session I want to moniter that error and show the error message to user as "This record was using by somebody else".  

Please suggest me necessary solution.

ASKED: Sep 22 2009  11:13 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
CharlieBrowne
6540 pts.
0
A:
 RATE THIS ANSWER
+1
Click to Vote:
  •   1
  •  0
  • AddThis Social Bookmark Button
You cannot lock the subfile record unless you locked all the records in the subfile.
But, you when a user selects a record, you can lock the DB record that is associated with the record.
You would do this by doing a chain and having the file identified as an Update File.
This is not a good solution as the user could walk away fromn this task and hte record would stay locked.
Generally, you take care of this programmatically..
When you write the subfile record, include a hidden fields of the database record.
Then when someone tries to do an update, compare the database record with the values in the hidden fields. If they do not match, someone else updated the record. nad you can display a message.
Last Answered: Sep 22 2009  12:55 AM GMT by CharlieBrowne   6540 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Teandy   3250 pts.  |   Sep 22 2009  2:37PM GMT

Go to:

 <a href="http://www.think400.dk/downloads.htm" title="http://www.think400.dk/downloads.htm" target="_blank">http://www.think400.dk/downloads.htm</a>

About a third of the way down the page you will find a program called “Show Record Lock”. You should be able to modify it to do what you want.

 
0