24,725 pts.
POSTED: Sep 22, 2009 2:37 PM (GMT)
Go to:
http://www.think400.dk/downloads.htm
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.
Record Lock in Subfile
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.
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
UPDATED:
September 22, 2009 2:37:19 PM GMT
RELATED QUESTIONS
- how to display blank rows in a subfile in rpgle
- Contention when locking an on-line VSAM file using ENQ/DEQ. All users are being locked out of entire file.
- Record locking in iSeries
- Record Locking
- Unable to browse local intranet PHP site
- remove a trigger file record lock
- Subfiles
- COBOL SubFile Processing
- Position Cursor Issue in subfile
- Error in subfile programming
Answer Wiki:
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.
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.
To see other answers submitted to the Answer Wiki View Answer History.
