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 |
when will come session device error?
3 members in databasefile .how to read records from all the members??
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
if there is pf in two libraries and there is a logical file based on the PF, how to find the pf on which the pf is based.
how do I preserve and clean the array?
which MONMSG will give higher priority in CL program? I know MONMSG are of two types. Program Level Monmsg and Command Monmsg?
Suppose i am having 3 programs PgmA,pgmB,pgmC and using source debugger. At debugging time i found that pgmC having some code error..then in debug mode directly how can i debug pgmC
There is a excel sheet having details of Old account number and new account number. I need to update these details in my AS400 files. i.e. all the records having old account number should be replaced with new account number. There can be 100 or 200 or 300 PFs...no fix files known. how can we do this?Solution should be performance oriented
what is the equivalent keyword for CHAIN opcode ??
purpose of pannel group??/
please help me answer to this question what is the difference between the binding and srvpgm in ilerpg?
What is the significance of UDATE?