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
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 |
WHERE DO WE USE COMIT KEYWORD IN AN RPG PROGRAM? YOU MADE SOME CHANGES TO DATABASE BUT YOU DON'T WANT TO SAVE THOSE CHANGES NOW? HOW DO YOU HANDLE THIS ONE?
suppose if we want to update the data in cl what we will do?
program to find the number of objects used in a given program through a display.
how to retrieve RRN value in RPGLE program
how do I do concatenation in rpg iv, like I do in cl?
Are all these RPG/400 Interviewed Questions being asked recently? are current?
I have a PF(ABC)with no key fields. PF(ABC)have 2 fields (cusno and cusname). Please let me know how can i read the cusno = 1150 directly from PF in CL and RPG program(Without creating the LF and without reading the complete file and then compare 1150)
how can we can we the data decimal error?how can we open such file in support
how can I tell when to replace the array?
what is overlay? how can we pass parameters in cl or rpg programing? how can we get data area value in cl or rpg programming?
Some times While checking MSGW for object / member / record locks ,I have seen it's locked by itself ...? How it happen and what action we need to perform if job is updating / writing a record....?
what is mean by *MAP and *DROP?what commands use these two keywords?why are they used?