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
Answer Posted / mahalakshmi
CPYFRMIMPF and then update the records by using SQL
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how do I preserve and clean the array?
how do I declare a minor?
1.Load an runtime array of length 99 from the pf and you want to handle all the possible errors?
which program rpg or cl is efficent to update a transaction onto a database file and why ?
How to declare the pull button in AS/400..
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?
what is the necessary keyword needed to scroll subfile records?
how can you display specific subfile page on the screen in unequal subfile?
what was the robotech rpg?
What is difference between bind by copy and bind by reference?
what is data area and how it is used in rpg program ?
can any one help in hawkeye and turnover or any change management system plzzzzz or send the documents to my mail id :gvsp.as4@gmail.com
What is the purpose of record level identifier?
What is the difference between copybooks and subprocedures in as400?
can I touch the array during treatments?