how do u find whether a record is locked or not??/

Answers were Sorted based on User's Feedback



how do u find whether a record is locked or not??/..

Answer / syam

DSPRCDLCK cammand will give locked record details

Is This Answer Correct ?    16 Yes 0 No

how do u find whether a record is locked or not??/..

Answer / madanmohan

If you know the RRN number of the record for which lock is
checked then in that case you can use DSPRCDLCK cmd.

To know the RRN number of specific record, use SQL statement

select RRN(A), A.* from FILE A where condition of the key
value.

Is This Answer Correct ?    10 Yes 0 No

how do u find whether a record is locked or not??/..

Answer / syam

Use command CHKRCDLCK

Is This Answer Correct ?    2 Yes 1 No

how do u find whether a record is locked or not??/..

Answer / khasim vali

WRKLCK USE THIS COMMAND IN RPG

Is This Answer Correct ?    0 Yes 0 No

how do u find whether a record is locked or not??/..

Answer / rajgoaj

Additional information:

Use WRKLCK to see whether the file is locked.

Is This Answer Correct ?    1 Yes 16 No

Post New Answer

More RPG400 Interview Questions

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

3 Answers   ISG,


How Commitment and Roll back control is used in as400, explain with real time senario ???

2 Answers   Acolite, HSBC,


Can we have a Physical file without any member ? Please let me know

12 Answers  


1.What is referential Integrity? 2.What is Foreign Key? 3.What is Transfer Control? 4.What is Free format?

3 Answers  


1.CA(command Atention key)& CF(command Function key) difference with example?Please can any body tell me in real time exp? 2.Can any body tell me some mandatery function keys using while creating any screen with use of SDA-FUNCTION kEYS?

5 Answers   HCL,






If I have a file with 5 record and that file has 2 Key field and I want to read the unique record of the file then how can we achieve it?

1 Answers  


1. If there are two programs using same file and 2 users are using the file at the same time and what can be done to allow them both to access? 2. How can remove lock from the file for accessing it by both users?

0 Answers  


1.Where we declare Variables in RPG/400,RPGIV,RPGILE.? 2.When do we use D-spec and I-spec in real time ?.what is difference between them?

1 Answers   HP,


How to search particular records from the database file in rpg?

2 Answers  


What are different ways to pass data between programs and which one is the efficient way?

5 Answers  


i want code and what are used key words are ...like wrkmbrpdm screen (q) i have a file with 3 fields empno,empname,empaddr... here you give the empno it displays from that number to remaining empno's how? sub file screen: employee details pos to:empno then enter empno empname empaddr so file have 100 records from 1 to 100 so the above pos you give the 55 empno...it displays the from 55 to remaining... ...... please share this answel

2 Answers   IBM,


what is overlay? how can we pass parameters in cl or rpg programing? how can we get data area value in cl or rpg programming?

2 Answers   IBM, Patni,


Categories