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

is this a rpg channel?

675


are there any useful c runtime apis that I can call from rpg iv?

698


write an RPG program to calculate the marks of 5 students (A,B, C, D, E)in 3 different subjects (eng, math, sci) an display on the screen

831


how does the rpg element work?

716


How to call one program from another program in RPG? please help me with the code

1260






How many program bind in one module....

2120


What is the difference between iter and do?

674


if there is a module object , how to find the program object for this module object.Assume the module object name and program object name is not same.

2193


Suppose we have one database file and it is used by 5 programs and in 3 program we have to add some records in datbase file s what is the impact on other program?

1453


What is ment by record level identifier?

652


how do I declare a table or array in rpg iv?

735


Explain mdt?

665


how do I declare a minor?

716


how do I play {insert rpg system here}?

585


Assume 2 users are using the same file and first user updates some record in the file. Will the 2nd user will be able to see the updated record or not?

515