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

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.

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 .

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

Answer / roshan.wankar

Before Perform Read operation, use SETLL and check Low
indicator is *ON then record is locked

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.

How to sort an array in descending in RPG

3 Answers   Google, TCS,

1.I Have a physical file , i want to read the data from the each and every member of the File in the CL Program.How do you achieve this. 2.How do you do the same in RPG?. do think is it possible to read data from all the members in the RPG?

2 Answers   Cap Gemini,

What are the necessary keywords required to code a message subfile?

3 Answers  

We have job which is running as batch. It takes atleast 06 hours to complete tht job. But I wanna do tht job with in 3 hours?

0 Answers  

What is the difference between iter and do?

0 Answers  

Hi friends, I am using a load all subfile , and currently i am in in the third page of the subfile , from third page i have selected a record and called some other program .on returning, subfile is being loaded from the frist page. so can any one kindly suggest me in retaining my third page after returning. i.e loading from third page.

7 Answers  

HOW TO DEBUG A BATCH JOB WHEN IT IS IN MESSAGEWAIT(MSWG) STATUS.I KNOW THE STEPS FOR BATCH DEBUGGING,BUT IM CONFUSING WITH WHEN WE SUBMIT ANY JOB FOR BATCH DEBUG WE PUT IN HELD STATE.SO HERE ALSO DO SAME THING OR ANY OTHER WAY,PLEASE HELP ME....

1 Answers   HCL, Mind Tree,

I have some doubts on subfile----------- -----I wrote a prog on subfile to display the records. Every thing is clear but i defined a field called "opt" as input field in subfile record format from that input field i wish to enter into new screen called "EDIT" which i created it as a separate RCD in display file. i gave opt as 2 for edit just like in WRKMBRPDM screen please telll me the code and how can i code for it in RPG.

3 Answers  

Need a sql query: retrive all duplicate records in table

3 Answers  

Hi, I am getting the error in RPG (All Record Formats for externally-described file ABCD ignored or dropped due to error; file ignored.) Please suggest any

2 Answers   Satyam,

steps involved in debugging and types of debugging modes?

1 Answers  

When it is desirable to describe files Internally?

0 Answers