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
- 3 Answers
- 8400 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is difference between bind by copy and bind by reference?
What is a record lock error?
how do you use commitment control in rpg?
what is the procedure and explain about real time scenario.
thanks mr.Harshad R Suryawaunshi,i'm new to as400 i think you are telling in rpgile i know only rpg400 if possible can you tell in rpg400
how do I declare a table or array in rpg iv?
can anybody help me to solve this problem. the program that i m checking display error message saying "Record format for file AJDSPFFD does not match model file and decimal error. how to solve this problem. The AJDSPFFD is snapshot the AJTLOG that is the audit trail list.
what is the difference between do while and do until?
1. If there are two programs using same file and 2 users are using the file at the same time and what can be done to allow them both to access? 2. How can remove lock from the file for accessing it by both users?
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?
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?
How to handle duplicate error handling in RPG?
How Chain operation copies the record's data to the input buffer for the program?
When it is desirable to describe files Internally?
can I touch the array during treatments?
