AS/400 record lock situation

635 pts.
Tags:
AS/400
AS/400 Subfiles
OS/400
Output Queues
I have two subfiles and each updates a file. A user uses the subfile and updates the record. At the same time the another user uses the same subfle and same program to update the same record. How to handle this situation?

Software/Hardware used:
OS/400

Answer Wiki

Thanks. We'll let you know when a new response is added.

This is a duplicate of your other question on programs P1 and P2.
See answer in that question.

Discuss This Question: 7  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Jaymz69
    I have the same thing happen on certain programs too. I would like to hear what others have to say, too.
    765 pointsBadges:
    report
  • philpl1jb
    Your program needs to keep an original set of data the change time stamp of the records, perhaps in hidden subfile fields. When the request to change is received by the program - chain into the physical file - check the original set of data against the set just received if the same update the record if different inform the user that the record has been changed and load and display the new record. Phil
    49,850 pointsBadges:
    report
  • TomLiotta
    How to handle this situation? How do you want it to be handled? What do you want the ideal actions to be? Tom (p.s. This is a different situation from the P1/P2 case.)
    125,585 pointsBadges:
    report
  • Sangay
    Is there a scenario that both users will face the record lock situation or only the second user? If both then how to use the record without unlocking it?
    635 pointsBadges:
    report
  • TomLiotta
    Again -- How do you want it to be handled? What do you want the ideal actions to be? The system would not be useful for business if programs could simply bypass record locks. No one would trust the system. But situations can be handled if you can say what you want to happen. Asking about "unlocking" won't get anywhere. It's a wrong question. Describe what you want to happen. We can describe ways to cause the process result that you are after. But the result needs to be a business result, not a technical result. "Unlocking" is a technical result. Tom
    125,585 pointsBadges:
    report
  • YuVa47
    The easiest and probably the most useful way is to inform the second user that the record is locked by displaying it in a small windows with the user code of the first user (the one who is locking the record). YuVa
    1,300 pointsBadges:
    report
  • Sangay
    [...] 7. Philpl1jb, TomLiotta, and YuVa47 gave a member some guidance regarding an AS/400 record lock situation. [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following