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 / 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 View All Answers
what is the use of sflnxtchg?
1. If there are two programs using same file and 2 users are using the file at the same time and what can be done to allow them both to access? 2. How can remove lock from the file for accessing it by both users?
what is *place and *auto keyword in prtf ?plz explain
What is file identifier where we can use?
what is the necessary keyword needed to scroll subfile records?
How do u design a physical file, when you have 2 Unique fields like for eg in A student file student ID and student examination no both are unique
How to define data area in RPG program? In which scenario multi occurrence DS is use in AS400?
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...........
How would display prime numbers using CL program?
how do I play {insert rpg system here}?
what happens when sflsiz = sflpag? What are the advantages and disadvantages?
can you debug ile rpg program using isdb?
How many program bind in one module....
is this a rpg channel?
how do I declare a minor?