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?



If I have a file with 5 record and that file has 2 Key field and I want to read the unique record of..

Answer / mahalakshmi

Give file level keyword as the unique based on first keyfield

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More RPG400 Interview Questions

what is the procedure and explain about real time scenario.

0 Answers   Adhoc Technologies, Hanuman Automation, HSBC, IBM,


What is the difference between iter and do?

0 Answers  


What are the necessary keywords required to code a message subfile?

3 Answers  


program to find the number of objects used in a given program through a display.

2 Answers   IBM,


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.

3 Answers   iGate, Wipro,






Can we journel logical file and access path? Can we use commitment control for non-join L.F?

4 Answers  


How to read alternative records in a pf by using rpg?

8 Answers   IBM,


what do you mean by an input subfile, what are the keywords required?

0 Answers   IBM,


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 add 2 new fields in a file? How many ways are there in as400?

2 Answers  


The PGMA calls PGMB.PGMB generates a report.The report should contain the called program name(PGMA).How do i get the called program name in PGMB to print it on the spool file?(calling program name should NOT be hard coded or passed as parameter to called program?

6 Answers  


what is estimation? and what is the level identifier parameter in PF?

3 Answers   TCS,


Categories