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 / 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
what is the use of sflnxtchg?
Interviewer asked me write down DDS for load all subfile .can anybody write dds
What is ment by record level identifier?
what are the key words you must use when using a subfile?
give an eg of ACQ-(ACQUIRE),BIT OFF,BIT ON,DEALLOC,DUMP,FEOD,FORCE,MHHZO,MHLZO,MHLLZO,MLHZO,REL,RESET,TESTZ,TESTB,TESTN----GIVE SMALL EXAMPLE TO THE OPCODES...TO UNDERSTAND FUNCTIONING...........
how can I tell when to replace the array?
What is the difference between iter and do?
which program rpg or cl is efficent to update a transaction onto a database file and why ?
what is data area and how it is used in rpg program ?
what is an online rpg?
what is *place and *auto keyword in prtf ?plz explain
How many program bind in one module....
can any one help in hawkeye and turnover or any change management system plzzzzz or send the documents to my mail id :gvsp.as4@gmail.com
How to declare the pull button in AS/400..
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?