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...
- 2 Answers
- 7698 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
what is the procedure and explain about real time scenario.
Interviewer asked me write down DDS for load all subfile .can anybody write dds
what happens when sflsiz = sflpag? What are the advantages and disadvantages?
is this a rpg channel?
what is a rpg?
what is program status data structure?
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...........
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 the diff bw PF/LF Name and their Record format name? what is restriction in record format then file name?
How to handle duplicate error handling in RPG?
If my rpg program has a date field, what extra care I have to take while compiling that rpg program? If the file is keyed and I have declared the file as well as key list properly in my program. Still am getting an error message like "chain/reade operation is not allowed" what may be the case?
can anybody help me to solve this problem. the program that i m checking display error message saying "Record format for file AJDSPFFD does not match model file and decimal error. how to solve this problem. The AJDSPFFD is snapshot the AJTLOG that is the audit trail list.
What are the types of identifiers?
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.
what is file information data structure?
