Answer / syam

DSPRCDLCK cammand will give locked record details

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.

Answer / syam

Use command CHKRCDLCK

Answer / khasim vali

WRKLCK USE THIS COMMAND IN RPG

Answer / rajgoaj

Additional information:

Use WRKLCK to see whether the file is locked.

What are the commands that can be executed in CLP but not in RPG? Why?

1 Answers   CSC,

give an eg of ACQ-(ACQUIRE),BIT OFF,BIT ON,DEALLOC,DUMP,FEOD,FORCE,MHHZO,MHLZO,MHLLZO,MLHZO,REL,RESET,TESTZ,TESTB,TESTN----GIVE SMALL EXAMPLE TO THE OPCODES...TO UNDERSTAND FUNCTIONING...........

0 Answers   CTS,

I have to change a program. This program is calling a subroutine mor than 100times within it. so will it have any performance issue? if yes than what changes i can make. Thanx for ur valuable answer.

2 Answers  

3. Given the DOS Specification below and the following information: • Indicator 50 is off • No records have been written to the subfile What will be the result if the EXFMT operation code is performed on the record format CTLR? A R SUBFL A DESCRIP 101 6 1ODSPATR(UL) A DFT(’NOT FOUND’) A R CTLR SFLCTL(SUBFL) A N50 SFLDSP A SFLDSPCTL A SFLINZ A 67 SFIJEND A SFLSIZ(13) A SFLPAG(12) A ACCOUNTNO 100 S 10 a.) Only AccountNo will display b.) SUBFL will be initialized with 13 blank records c.) An I/O exception error will occur d.) The screen will display 12 records with ‘NOT FOUND’

4 Answers   IBM,

How do you proceed in case your active AS400 session has got disconnected suddenly, how can you get back to your session ? Is it possible??

1 Answers  

Are all these RPG/400 Interviewed Questions being asked recently? are current?

1 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,

how to display all the members records in a physical file without using ovrdbf?

9 Answers  

what is mean by *MAP and *DROP?what commands use these two keywords?why are they used?

4 Answers  

I want to add 10 days in current date. how it is possible in CL program...?

11 Answers   CSC,

how do I preserve and clean the array?

0 Answers   IBM,

What is the significance of UDATE?

5 Answers   IBM,