Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

which program rpg or cl is efficent to update a transaction onto a database file and why ?

1235


can I touch the array during treatments?

1158


what is the necessary keyword needed to scroll subfile records?

1144


can you debug ile rpg program using isdb?

1253


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...

1872


What is the difference between copybooks and subprocedures in as400?

1348


How to write record if no field or the field are different in physical file in rpgle ?

947


what is the difference between do while and do until?

1236


how do I play {insert rpg system here}?

1027


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.

2615


How can we know running job is batch or interactive?

1108


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?

1239


How to select highest score of each subject or how to select highest income of every month?

1751


are there any useful c runtime apis that I can call from rpg iv?

1151


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.

1202