Re: Record locking

["Quazy" <quazy@xxxxxxxxxxxx>]

Well I looked at the call stack and no previous program uses the file, and
nobody else could be using the file because I am the only person with access
to these files and they are in test.

The record is locked by the previous update and it just won't let go for
anything.

I am not updating any logical files so it is not that.

Chris


----- Original Message -----
From: "Joep Beckeringh" <joep@beckeringh.myweb.nl>
To: <RPG400-L@midrange.com>
Sent: Tuesday, May 30, 2000 4:40 PM
Subject: Re: Record locking


> 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
> +---
>

+---
| 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
+---