How to get only unique records from a file which contains duplicate data using CPYF command ?
Example : FILEA has duplicate records and FILEB is a UNIQUE defined.... and I want to get the data from FILEA to FILEB by eliminating all the duplicate records...
Answer Posted / murali
First read PF and use pass data to the key fields of LF and check if record already find then skip if not then add record to LF.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
which program rpg or cl is efficent to update a transaction onto a database file and why ?
can I touch the array during treatments?
what is the necessary keyword needed to scroll subfile records?
can you debug ile rpg program using isdb?
How to create a login screen using a command instead of display file.... intention is to get a password field on a command..... how do you achieve this...
What is the difference between copybooks and subprocedures in as400?
How to write record if no field or the field are different in physical file in rpgle ?
what is the difference between do while and do until?
how do I play {insert rpg system here}?
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.
How can we know running job is batch or interactive?
We have job which is running as batch. It takes atleast 06 hours to complete tht job. But I wanna do tht job with in 3 hours?
How to select highest score of each subject or how to select highest income of every month?
are there any useful c runtime apis that I can call from rpg iv?
during execution, an rpg/400 program automatically follows a sequence of operations for each record that is processed. The built-in program cycle includes the following logical steps.