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


Please Help Members By Posting Answers For Below Questions

how do I preserve and clean the array?

675


how do I declare a minor?

716


1.Load an runtime array of length 99 from the pf and you want to handle all the possible errors?

2373


which program rpg or cl is efficent to update a transaction onto a database file and why ?

745


How to declare the pull button in AS/400..

1878






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?

768


what is the necessary keyword needed to scroll subfile records?

702


how can you display specific subfile page on the screen in unequal subfile?

673


what was the robotech rpg?

684


What is difference between bind by copy and bind by reference?

1730


what is data area and how it is used in rpg program ?

756


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

1968


What is the purpose of record level identifier?

728


What is the difference between copybooks and subprocedures in as400?

806


can I touch the array during treatments?

756