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...
- 2 Answers
- 7012 Views
- I also Faced
- E-Mail Answers
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
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...........
do you use message subfiles? What are the necessary keywords required coding a message subfile?
Please tell me how to read the records from a file with load an array of size with error conditions(The logic answer for this question is ARR is array of 99 elements Z-ADD 0 IDX *LOVAL SETLL FILE READ FILE 99 *IN99 DOWEQ *OFF IDX ANDLT 99 ADD 1 IDX MOVE FIELD ARR,IDX READ FILE 99 ENDDO).So,Please give me the complete of this code.
how do I preserve and clean the array?
what is kids-rpg?
what was the robotech rpg?
which program rpg or cl is efficent to update a transaction onto a database file and why ?
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.
How Chain operation copies the record's data to the input buffer for the program?
How would display prime numbers using CL program?
can any one help in hawkeye and turnover or any change management system plzzzzz or send the documents to my mail id :gvsp.as4@gmail.com
How many program bind in one module....
What is ment by record level identifier?
what do you mean by an input subfile, what are the keywords required?
How to define data area in RPG program? In which scenario multi occurrence DS is use in AS400?
