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
- 7849 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 do I declare a table or array in rpg iv?
which program rpg or cl is efficent to update a transaction onto a database file and why ?
1.I have a Batch job, Running for 4 hours, i want to reduce the executing time to 2 hours what should you do?
what is the necessary command needed before OPNQRYF and why?
we hav job which is running as batch. it takes atleast 06hours to complete tht job. bu i wana do tht job with in 3hours.........? so plz post ur answers
Can more than one subfile record be displayed on one line?
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?
how do I declare a minor?
Why there is invention of RPG if we can do insert update delete in CL through SQL.Why the rise of RPG?
how to retrieve RRN value in RPGLE program
How to change the name of physical members Dynamically?
A rpg or clp command to find if the file field is defined as a character or numeric field.
RPG400 
