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....?
Answer Posted / 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 |
Post New Answer View All Answers
How do u design a physical file, when you have 2 Unique fields like for eg in A student file student ID and student examination no both are unique
What is a record lock error?
How to call one program from another program in RPG? please help me with the code
1. What is bound-by-call and bound-by-reference? 2. Where and why is *Nomain used? 3. What are the difficulties faced by programmers when using service programs? 4. Explain the different ways of parsing and compiling XML in iSeries.
Suppose we have one database file and it is used by 5 programs and in 3 program we have to add some records in datbase file s what is the impact on other program?
how do I declare a table or array in rpg iv?
What is the difference between iter and do?
how does the rpg element work?
What is file identifier where we can use?
When we have a file with Duplicate records and I want to read the unique record from the file. For example a file containing Emp Name as 'Ram' and there are 3 entries of it. So how to read a unique record from File?
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...?
what is the difference between do while and do until?
How can we override a file during runtime in rpg?
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?
what happens when sflsiz = sflpag? What are the advantages and disadvantages?