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

Answers were Sorted based on User's Feedback



How to get only unique records from a file which contains duplicate data using CPYF command ? Exa..

Answer / 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

How to get only unique records from a file which contains duplicate data using CPYF command ? Exa..

Answer / sandey243

There is an option in CPYF command which says " Error Allowed", making that as *NOMAX will trigger IGNORE option instead of CANCEL in CPYF processing; whenever there is duplicate record encountered.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More RPG400 Interview Questions

i)What is the command to lock a file in a program ii)2. Can you get a level check error in a CL program

6 Answers  


How can we call CL program to RPG? How many number of parameter we can pass

2 Answers   TCS,


Is it possible to call a subfile using CL. IF yes.. kindly help me out with explanation...?

3 Answers  


1.The questions have given an array declaration and move operation then this statement is correct or not?

3 Answers   TCS,


I have a Physical File name 'File1', which is present in two libraries named 'LIB1' & 'LIB2'. These 2 libraries are listed in the library list. Would like to access data from this file from these two libraries using RPG program. How to do this, any idea?

4 Answers  


wat is the difference between array and multiple occurence data structure?

4 Answers   Four soft,


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?

0 Answers  


thanks mr.Harshad R Suryawaunshi,i'm new to as400 i think you are telling in rpgile i know only rpg400 if possible can you tell in rpg400

0 Answers   iGate,


How can we override a file during runtime in RPG? Without using OVRDBF or calling a CL program

1 Answers   UST,


I have file with data as follows data 1 2 3 4 5 I need to read 1 and 5 ,then 2 and 4 then like.. upto end of file, can any one help on this

3 Answers   ISG,


can i use unique key in LF

3 Answers   TCS,


what is the equivalent keyword for CHAIN opcode ??

7 Answers   TCS,


Categories