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

We have a Physical file, after reading 5 records,it has to read LF of that same Physical file,Will it start reading from Ist record or will start reading from 5th record?

5 Answers   Hexaware,


How can i keyed a flat file in RPGLE

5 Answers   IBM, Wipro,


what happens when sflsiz = sflpag? What are the advantages and disadvantages?

0 Answers   IBM,


what is post opcode do

1 Answers   CTS,


give an eg of ACQ-(ACQUIRE),BIT OFF,BIT ON,DEALLOC,DUMP,FEOD,FORCE,MHHZO,MHLZO,MHLLZO,MLHZO,REL,RESET,TESTZ,TESTB,TESTN----GIVE SMALL EXAMPLE TO THE OPCODES...TO UNDERSTAND FUNCTIONING...........

0 Answers   CTS,


check existence of one record without using chain or read?

1 Answers   IBM,


what is kids-rpg?

0 Answers   IBM,


I have 1000 records in a file. I would like to generate 10 identical reports from this record with same format (structure of records) how do I do this?

1 Answers   IBM,


parameters cannot be passed in which one???

4 Answers   CTS,


what is batch debug in as400?

3 Answers  


what is the necessary keyword needed to scroll subfile records?

0 Answers   IBM,


What is the syntax of passing parameters to a procedure by value?

1 Answers  


Categories