Some times While checking MSGW for object / member /
record locks ,I have seen it's locked by itself ...? How
it happen and what action we need to perform if job is
updating / writing a record....?
Answers were Sorted based on User's Feedback
Answer / guru
Usually a record lock will happen when you read a file
itself. To avoid file locks, use the following ways
1.Read(N)Read with no lock
2.When your file is in update mode and if you use any chain
function, then use Chain(N)
Cheers...
| Is This Answer Correct ? | 13 Yes | 1 No |
Answer / duvara (duvara.cse@gmail.com)
when the file is opened in update mode, when u chain the
same record two time continuously with out any updation bw
2 chains then u can face this problem. because the record
is locked by the first chain operation, so cannot chain the
same record again.
To relese the record simply update that record befor the
next chain/read.
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / rakesh roshan
This is true because either it must be updating the File or
Writing the record to the file and it places *EXCL Lock .
To handle such exception it depends upon the
Application ,if we want to handle such lock we can chain(N)
extender but then we need to see whether the File it is
writing or updating is having some constraints associated
or not , if yes
then we can handle the exception by using %Status of PSDS
DS and wait for few seconds and Retry it .
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / kathan
when u open file in update mode the record is automatic lock
to remove these condition u can use in ipc prompt N in H/N/P
entry
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / roshan.wankar
Before Perform Read operation, use SETLL and check Low
indicator is *ON then record is locked
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / syam
Two user is trying to write or update same record it is
geting lock.
1. Do change in your program all view and report program
open om Read mode only.
2. Do change in your program before update or write check
record is used by another user or not.
| Is This Answer Correct ? | 2 Yes | 6 No |
Hi,Please give me complete code with this logic. The question is how to read the records from a file with load an array of size with error condition? (The logic is Z-Add 0 IDX *LOVAL SETLL FILE READ FILE 99 *IN9 DOWEQ *OFF IDX ANDLT 99 ADD 1 IDX MOVE FIELD ARR,IDX READ FILE 99 ENDDO)please give me complete code with explanation?
two types of read performed in dataqueue?????
I have a RPG program of 100 Lines and first line is to SETON indicator LR. Will the program execute rest of the 99 Lines?
steps involved in debugging and types of debugging modes?
What is ment by record level identifier?
how to display all the members records in a physical file without using ovrdbf?
how can we find setll setgt chain read reade readp operations are successfull or not,give example.explain in detail.
can i use unique key in LF
how we create binder member for updating service program and where we type this code on command line or in program ? strpgmexp pgmlvl(*current) export symbol (xyz0 endpgmexp. plz explain me this step by step .
Hi Viewers can any body explain me how to update and ahange the already existed data in physical file using subfile ? please explain me with the code if possible?
Let?s consider a variable X of length 20. Move value ?ABC? to it.How to determine how many characters does X have?
Write a program to display prime numbers between 1 to 100 using RPGLE.