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
- 8343 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
Interviewer asked me write down DDS for load all subfile .can anybody write dds
what do you mean by an input subfile, what are the keywords required?
what is *place and *auto keyword in prtf ?plz explain
How to define data area in RPG program? In which scenario multi occurrence DS is use in AS400?
which program rpg or cl is efficent to update a transaction onto a database file and why ?
what is the use of sflnxtchg?
If my rpg program has a date field, what extra care I have to take while compiling that rpg program? If the file is keyed and I have declared the file as well as key list properly in my program. Still am getting an error message like "chain/reade operation is not allowed" what may be the case?
can you debug ile rpg program using isdb?
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?
during execution, an rpg/400 program automatically follows a sequence of operations for each record that is processed. The built-in program cycle includes the following logical steps.
explain sflclr, sflend, sfldlt, and sflcsrrrn?
What is a record lock error?
How Chain operation copies the record's data to the input buffer for the 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?
what are the key words you must use when using a subfile?
