When we have a file with Duplicate records and I want to read the unique record from the file. For example a file containing Emp Name as 'Ram' and there are 3 entries of it. So how to read a unique record from File?
- 1 Answers
- 1047 Views
- I also Faced
- E-Mail Answers
Answer Posted / Om Pal Singh
To read a unique record (i.e., removing duplicates) from a file in RPG400, you can implement a key sequence comparison on the duplicate fields and only process the first occurrence of each unique combination of keys. Alternatively, you may use SQL statements to eliminate duplicates using the DISTINCT keyword or grouping functions.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
