Re: File locking / field locking

Hi Doug,

No, the record is still locked, until you do another operation on that
record itself. Adding a new record does not release the record you
already have locked. You have to release the locked record by doing
another Read, Except, Setxx, Update, etc...



Thanx,

Nick



Nick Radich
Sr. Programmer/Analyst
EPC Molding, Inc.
Direct (320) 679-6683
Toll free (800) 388-2155 ext. 6683
Fax (320) 679-4516
nick_radich@xxxxxxxxxxxxxx



Doug Palme <DPalme@xxxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
10/17/2008 08:56 AM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
RPG Midrange L <rpg400-l@xxxxxxxxxxxx>
cc

Subject
File locking / field locking






I have two files SourcePF is my physical file and SourceLF is a logical
built over that PF. Both are included in the program as update files
with
add.

In a subroutine the program sets a HIVAL on the logical and then does a
readp in order to get the highest shipping number. At this point I
believe this field is locked and no other process can access read that
record. it then increrments the count and writes it to a variable. The
other variables are setup and then the program finally writes a new
record
to the Physical file, which at that point the lock is released correct?

I am just checking every possible place for this thing to create
duplicate
records (I did not write the code, just plugging the hole).....and
making
sure that neither program can dup up the same number.
This transmission may contain information that is privileged,
confidential
and/or exempt from disclosure under applicable law. If you are not the
intended recipient, you are hereby notified that any disclosure,
copying,
distribution, or use of the information contained herein (including any
reliance thereon) is STRICTLY PROHIBITED. If you received this
transmission in error, please immediately contact the sender and
destroy
the material in its entirety, whether in electronic or hard copy
format.
Thank you.