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
- 9856 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 can we know running job is batch or interactive?
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?
during execution, an rpg/400 program automatically follows a sequence of operations for each record that is processed. The built-in program cycle includes the following logical steps.
how do you use commitment control in rpg?
explain sflclr, sflend, sfldlt, and sflcsrrrn?
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...?
how do I declare a table or array in rpg iv?
Explain mdt?
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
How to create a login screen using a command instead of display file.... intention is to get a password field on a command..... how do you achieve this...
what is the procedure and explain about real time scenario.
How to call one program from another program in RPG? please help me with the code
How Chain operation copies the record's data to the input buffer for the program?
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.
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
