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
is this a rpg channel?
are there any useful c runtime apis that I can call from rpg iv?
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
how does the rpg element work?
How to call one program from another program in RPG? please help me with the code
How many program bind in one module....
What is the difference between iter and do?
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.
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?
What is ment by record level identifier?
how do I declare a table or array in rpg iv?
Explain mdt?
how do I declare a minor?
how do I play {insert rpg system here}?
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?