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.

Why we need to give File and To file Names While we are using OVRDBF. What is your understanding related to this?

2 Answers   Cap Gemini,

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

13 Answers   IBM,

how can we know running job is batch or intractive ? i need all the possibilites.........plz help me

3 Answers   HSBC, IBM,

1.How can you search an entire source file for a particular field name? 2.How can you find the differences between two versions of the source for the same program? 3.What is a hidden field as it relates to a sub file? 4.How do you display a sub file that has no records in the sub file?

8 Answers   HCL,

What are the values of NUM1 and NUM2 after executing the following code? CLONO1NO2NO3 Factorl÷÷+OpcdeFactor2+÷+ResultLenDHHiLoEq C MOVE *LOVAL NUM1 50 C MOVE *J-fIVAL NtJM2 52

2 Answers   Fiserv, IBM,

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

2 Answers   UST,

I have 1000 records in a file. I would like to generate 10 identical reports from this record with same format (structure of records) how do I do this?

1 Answers   IBM,

Q1.How we can copy the data of file one session to another session? Q2.how we can execute a loop infinitely in AS/400 coding? Q3.In ALDON tool,multitask is posible on a perticular object by the user?

6 Answers   CSC,

what is kids-rpg?

0 Answers   IBM,

1.WHAT IS WRONG WITH THE CODE BELOW? C CUSTNO CHAIN CUSTMAST IF %ERROR can any body find the wrong please? 2.What builtin function will you use to achieve the following functionality? C QTY IFLT *ZERO C QTY MULT-1 QTY ENDIF

5 Answers   CTS,

Is it possible to call a subfile using CL. IF yes.. kindly help me out with explanation...?

3 Answers  

Thanks gagan for your answer,i'm new to as400,i don't know embedded sql in rpg.can you send me the coding for the below mentioned question in embedded sql rpg. how to retrieve particular field records from a physical file,say i have a physical file called 'employee' in it i have to retrieve the records of a field 'admin' present in pf 'employee' using rpg,but i should not use logical file or openquery file.

2 Answers   iGate,