Re: Record locking

["Joep Beckeringh" <joep@xxxxxxxxxxxxxxxxxxx>]

Chris,

If unlock and close/open don't work, it is not this program that is holding
the lock; there must be another program.  This program may be in another or
in the same job.  Are you calling another program that reads the file for
update?  Are there any triggers?  Through DSPJOB you can find out which
record your program is waiting for and which job is holding it.

Joep Beckeringh


----- Original Message -----
From: Quazy
To: RPG400-L@midrange.com
Sent: Tuesday, May 30, 2000 10:52 PM
Subject: Record locking


I have a program that when a user deletes a record it just marks the record
for delete, that way all the data is all still there if we need to get it
back.   But if a user decides they did not want to delete the record and
recreates it before they exit that portion of the app they cant because the
record is still locked.   I have tried using the unlck command and I have
tried closing the file and opening it back up again but nothing seems to
work.   the lock gets hung up on a chain command.       Am I just doing this
wrong or what, any suggestions would be greatly appreciated.



Thanks Chris

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---