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
Answers were Sorted based on User's Feedback
Answer / kusum
Excel sheet needs to converted in DB file. We can use AS400
utility or FTP to do so. Once it is converted in DB file. We
can use SQL update script to update the Database.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / smita
We can convert the excel sheet into file by command
CPYTOIMPF. Read this file and write programs to update 100 -
200 files for given updation of old account number. But
this solution will not provide gud performance. Is there
any other solution?
Is This Answer Correct ? | 3 Yes | 3 No |
Answer / mahalakshmi
CPYFRMIMPF and then update the records by using SQL
Is This Answer Correct ? | 0 Yes | 0 No |
in which journalling which attributes are necessary
How can we override a file during runtime in rpg?
Can we journel logical file and access path? Can we use commitment control for non-join L.F?
there is any limit to display the members in rpg400?
what is the difference between the procedure and module in ILERPG?
difference between 1:%found and %equal built function in detail with example .
how does the rpg element work?
WHAT IS MENT BY RECORD LEVEL IDENTIFIER ? WHAT IS THE PURPOSE OF THIS?
can anybody explain significance of *loval setll with example code????
How to declare the more than one file in cl/400.
are there any useful c runtime apis that I can call from rpg iv?
What is significance of a file designated as a Primary file in Rpg400 program....also what's use of secoundry file