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 |
i)What is the command to lock a file in a program ii)2. Can you get a level check error in a CL program
How can we call CL program to RPG? How many number of parameter we can pass
Is it possible to call a subfile using CL. IF yes.. kindly help me out with explanation...?
1.The questions have given an array declaration and move operation then this statement is correct or not?
I have a Physical File name 'File1', which is present in two libraries named 'LIB1' & 'LIB2'. These 2 libraries are listed in the library list. Would like to access data from this file from these two libraries using RPG program. How to do this, any idea?
wat is the difference between array and multiple occurence data structure?
We have job which is running as batch. It takes atleast 06 hours to complete tht job. But I wanna do tht job with in 3 hours?
thanks mr.Harshad R Suryawaunshi,i'm new to as400 i think you are telling in rpgile i know only rpg400 if possible can you tell in rpg400
How can we override a file during runtime in RPG? Without using OVRDBF or calling a CL program
I have file with data as follows data 1 2 3 4 5 I need to read 1 and 5 ,then 2 and 4 then like.. upto end of file, can any one help on this
can i use unique key in LF
what is the equivalent keyword for CHAIN opcode ??