Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9995 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
explain sflclr, sflend, sfldlt, and sflcsrrrn?
What is the difference between iter and do?
How can we know running job is batch or interactive?
Program to read marks of 10 students for 4 subjects and compute and display total marks and status of each student in rpg
how do I preserve and clean the array?
How to select highest score of each subject or how to select highest income of every month?
which program rpg or cl is efficent to update a transaction onto a database file and why ?
Hi Viewers can any body explain me how to update and ahange the already existed data in physical file using subfile ? please explain me with the code if possible?
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 is *place and *auto keyword in prtf ?plz explain
1. What is bound-by-call and bound-by-reference? 2. Where and why is *Nomain used? 3. What are the difficulties faced by programmers when using service programs? 4. Explain the different ways of parsing and compiling XML in iSeries.
how do I play {insert rpg system here}?
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?
what is a rpg?
how do I declare a table or array in rpg iv?
