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
- 9682 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
How can we override a file during runtime in rpg?
what is file information data structure?
what is the necessary keyword needed to scroll subfile records?
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?
What is difference between bind by copy and bind by reference?
what is kids-rpg?
how can I tell when to replace the array?
how do I declare a table or array in rpg iv?
is this a rpg channel?
When we have a file with Duplicate records and I want to read the unique record from the file. For example a file containing Emp Name as 'Ram' and there are 3 entries of it. So how to read a unique record from File?
How to declare the pull button in AS/400..
We have job which is running as batch. It takes atleast 06 hours to complete tht job. But I wanna do tht job with in 3 hours?
do you use message subfiles? What are the necessary keywords required coding a message subfile?
How Chain operation copies the record's data to the input buffer for the program?
How to call one program from another program in RPG? please help me with the code
