+ Reply to Thread
Results 1 to 3 of 3

Thread: Record Locks

  1. #1
    K.Forsythe Guest

    Default Record Locks

    Simply insert a DSPRCDLCK command (or a series of them) to display record locks for all the files involved, into the CL program. This allows the user to see and deal with any record locks before starting the process. You may want to include a mechanism that allows the user to loop back up and recheck all files again. A programming solution would be better if you have that option - but based on the way you asked the question, I assume you cannot modify the code for one reason or another. I hope this helped. Kevin

  2. #2
    Guest.Visitor Guest

    Default Record Locks

    We frequently have issues with record locks in payroll when running an update CL. We would like to program something in the submitted CL that informs the user of any file locks so they can do the legwork and resubmit. I have looked at ALCOBJ, *EXCLRD, member *ALL and I can determine who has a file open for update, but other than writing a program, is there a way to find the locks and retrieve the user names and return them to the user who submitted the CL? Is there a better option than ALCOBJ?

  3. #3
    Guest.Visitor Guest

    Default Record Locks

    A programming solution would be cleaner, but due to the number of files and programs involved, and our rigid Sarbanes-Oxley requirements, we are looking for a faster way. Your solution took less time. Thanks.

+ Reply to Thread

Similar Threads

  1. record locks
    By K.Forsythe in forum General
    Replies: 2
    Last Post: 08-17-2004, 06:54 AM
  2. Record Locks
    By B.Morris in forum RPG
    Replies: 2
    Last Post: 08-29-2003, 06:02 AM
  3. Record locks - Need help!
    By Guest.Visitor in forum IBM i (OS/400, i5/OS)
    Replies: 3
    Last Post: 02-22-2002, 10:20 AM
  4. Viewing job/record locks
    By Guest.Visitor in forum Application Software
    Replies: 2
    Last Post: 11-17-2000, 02:39 PM
  5. SQL Record Locks
    By Guest.Visitor in forum Application Software
    Replies: 0
    Last Post: 01-01-1995, 02:00 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts