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

where we give the MSGSFL in rpg400?

4 Answers  


Assume 2 users are using the same file and first user updates some record in the file. Will the 2nd user will be able to see the updated record or not?

0 Answers  


can i use UPDDTA command in rpg program in which contains a file

1 Answers   TCS,


HOW TO DEBUG A BATCH JOB WHEN IT IS IN MESSAGEWAIT(MSWG) STATUS.I KNOW THE STEPS FOR BATCH DEBUGGING,BUT IM CONFUSING WITH WHEN WE SUBMIT ANY JOB FOR BATCH DEBUG WE PUT IN HELD STATE.SO HERE ALSO DO SAME THING OR ANY OTHER WAY,PLEASE HELP ME....

1 Answers   HCL, Mind Tree,


if there is a module object , how to find the program object for this module object.Assume the module object name and program object name is not same.

0 Answers  






What is the difference between copybooks and subprocedures in as400?

0 Answers  


How can we make use of SETLL operation in CL?

11 Answers  


how to check on which PF , the LF is dependant ?

4 Answers   IBM,


1.What is the Maximum field length we can declare in RLU?? 2. What is the difference if your designing RLU using DDS and using the option 19 for the RLU??

2 Answers  


1.Suppose my file has 10 fields and I want to make the 2nd field Zeros in all records. And assume I have millions of records and I dont want to read each record and update the desired field with 0. Any other way to do this in one step operation? 2. Assume my file has 100 records and I want to see only first 10 records. Is this possible through LF? 3.I have 3 jobs A B and C. I want to submit B after successful completion of A and want to submit C after successful completion of B. Without using job scheduler or job queue, how can i do that through CL program? 4.What is difference between Bind by copy and bind by reference?

4 Answers   Virtusa,


How can we access Interactive job LDA in Batch Job?. and How we can access a file in interactive QTEMP lib in Batch job?.

4 Answers   IBM,


Difference between creating a report using Printer file and WRKQRY(Query Report) ?

3 Answers  


Categories