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
- 9860 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
what is the procedure and explain about real time scenario.
how can you display specific subfile page on the screen in unequal subfile?
How to define data area in RPG program? In which scenario multi occurrence DS is use in AS400?
what is the rpg system?
explain sflclr, sflend, sfldlt, and sflcsrrrn?
what is the necessary keyword needed to scroll subfile records?
How can we know running job is batch or interactive?
Q:Hi all,i want accurate answer with code using in built functions.please sent me code as soon as posible. I have program nmed PGM1 which '' RETRIEVE Current production date''should correctly default the production date for the user who is issuing raw materials to the manufacturing.The production date can be different from the celendra date. However, the program does not make the correct adjustment for all manufacturing plants. there is a parameter which determines the production start time e.g. 07:00 if the system time precedes this,the program subtracts one from the celendra day.This work fine when the celendar day starts after production day as it does in England,the system should be adding one to the celendar day during the overlap. unfortunately the program was desined to assumed the celendar day always starts before the production day. Change required in the program: Change the PROGRAM PGM1 to use the new parrameter to decide whether to add or subtract 1 from the celendar day when determining the production date.
What are the types of identifiers?
What is ment by record level identifier?
how does the rpg element work?
what is kids-rpg?
What is the difference between iter and do?
What is the diff bw PF/LF Name and their Record format name? what is restriction in record format then file name?
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
