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
- 9992 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
can anybody help me to solve this problem. the program that i m checking display error message saying "Record format for file AJDSPFFD does not match model file and decimal error. how to solve this problem. The AJDSPFFD is snapshot the AJTLOG that is the audit trail list.
can I touch the array during treatments?
what is *place and *auto keyword in prtf ?plz explain
what was the robotech rpg?
which program rpg or cl is efficent to update a transaction onto a database file and why ?
How to declare the pull button in AS/400..
thanks mr.Harshad R Suryawaunshi,i'm new to as400 i think you are telling in rpgile i know only rpg400 if possible can you tell in rpg400
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.
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?
What is the diff bw PF/LF Name and their Record format name? what is restriction in record format then file name?
How to call one program from another program in RPG? please help me with the code
What is a record lock error?
How to select highest score of each subject or how to select highest income of every month?
what is the necessary keyword needed to scroll subfile records?
is this a rpg channel?
