Interested to Buy Any Domain ? << Click Here >> for more details...
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....?
- 6 Answers
- 15377 Views
- HSBC, I also Faced
- E-Mail Answers
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 |
In RPG program one file using as a PRIMARY file while running program some of the records reading twice any body know why its happening
In how many ways a session/device error occurs,,, and what is the remedy for it?
I have file with data as follows data 1 2 3 4 5 I need to read 1 and 5 ,then 2 and 4 then like.. upto end of file, can any one help on this
How to define data area in RPG program? In which scenario multi occurrence DS is use in AS400?
If the last record of a file has been read, and the next operation on that file is a READ operation, what will be the values of the input fields for that file? A. They will be blank and/or zero. B. They will be null. C. They will equal the values of the first record in the file. D. They will equal the values of the last record read.
in which journalling which attributes are necessary
If there are 1000 member(PGM type) in a SRC file. How can we compile in a CL program? ( It need to be done in a loop)?
CAN WE READ RECORDS WITHOUT USING SETLL,READ,CHAIN IN RPG?
wat is curser?? and its types???
How to sort an array in descending in RPG
Set on command is used for closed all opened files , initialize var and release resource , return cmd is used for return to calling program but my req. Is dnt close opened files and resource must released while doing transactions , how can i do this...?
HOW TO DELETE THE RECORD FROM MASTER FILE WHICH IS LINK BY ANOTHER TRASATION FILE WITH REFERTIAL INTYGRITY?
RPG400 
