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
- 9688 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
How do u design a physical file, when you have 2 Unique fields like for eg in A student file student ID and student examination no both are unique
How to define data area in RPG program? In which scenario multi occurrence DS is use in AS400?
how do I declare a table or array in rpg iv?
How can we know running job is batch or interactive?
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?
How can we override a file during runtime in rpg?
how does the rpg element work?
How to handle duplicate error handling in RPG?
How would display prime numbers using CL program?
When it is desirable to describe files Internally?
How to declare the pull button in AS/400..
How to write record if no field or the field are different in physical file in rpgle ?
Set on command is used for closed all opened files , initialize var and release resource , return cmd is used for return to calling program but my req. Is dnt close opened files and resource must released while doing transactions , how can i do this...?
What is difference between bind by copy and bind by reference?
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?
