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



Some times While checking MSGW for object / member / record locks ,I have seen it's locked ..

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

Some times While checking MSGW for object / member / record locks ,I have seen it's locked ..

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

Some times While checking MSGW for object / member / record locks ,I have seen it's locked ..

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

Some times While checking MSGW for object / member / record locks ,I have seen it's locked ..

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

Some times While checking MSGW for object / member / record locks ,I have seen it's locked ..

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

Some times While checking MSGW for object / member / record locks ,I have seen it's 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.

Is This Answer Correct ?    2 Yes 6 No

Post New Answer

More RPG400 Interview Questions

can we perform CHAIN operation on Subfile record format....?

4 Answers  


A particular job executing on the iS is not behaving as expected and is operating in an environment in which it can be debugged. What commands would you use to debug and observe the program?

2 Answers   IBM,


Let?s consider a variable X of length 20. Move value ?ABC? to it.How to determine how many characters does X have?

1 Answers  


What is I90(Insure 90)?

1 Answers  


how does the rpg element work?

0 Answers   IBM,






When it is desirable to describe files Internally?

0 Answers  


How can you delete a record from a file in RPG without using DELETE oppcode?

2 Answers   UST,


What is the difference Return and InLr?

3 Answers  


Can AnyOne tell me how to read join logical file in rpg from starting to end?

2 Answers  


How do you call procedures in ILE?

3 Answers  


How can we override a file during runtime in rpg?

0 Answers  


How to declare the more than one file in cl/400.

13 Answers   IBM,


Categories