Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> MainFrame >> IBM AS400 >> RPG400
  2. Suggest New Category

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

Question Posted / smita

Answers were Sorted based on User's Feedback



There is a excel sheet having details of Old account number and new account number. I need to upda..

Answer / 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

There is a excel sheet having details of Old account number and new account number. I need to upda..

Answer / 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

There is a excel sheet having details of Old account number and new account number. I need to upda..

Answer / mahalakshmi

CPYFRMIMPF and then update the records by using SQL

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More RPG400 Interview Questions

wat is curser?? and its types???

4 Answers   HSBC,

How to code Page up and Page down in RPG for Single page subfile without using ROLLUP/ROLLDOWN in DSPF ?

3 Answers   HCL,

i have 6 char field in program, but this field is using in all files i want to chage field size as 10 char , how can i do this except using *like defn...?

1 Answers   IBM,

what is meant by record lock.how records are locked.what is the purpose of record lock.if records are locked what happens.how to find out which record is locked.

4 Answers   HCL,

Hi, can any one tell me :IN CASE OF SINGLE PAGE FILE HOW WILL I LOAD THE PREVIOUS PAGE WITHOUT THE USE OF SFLCLR INDICATOR ?

3 Answers   IBM,

can anybody help me that what is the procedure of debugging the service program?

3 Answers   CSC,

What will happen if we r using seton lr after return or vice versa.

5 Answers  

HOW TO DELETE THE RECORD FROM MASTER FILE WHICH IS LINK BY ANOTHER TRASATION FILE WITH REFERTIAL INTYGRITY?

1 Answers   TCS,

can we perform CHAIN operation on Subfile record format....?

4 Answers  

How do you proceed in case your active AS400 session has got disconnected suddenly, how can you get back to your session ? Is it possible??

1 Answers  

what will happen two jobs have same name are submitted

5 Answers   CTS,

can i use unique key in LF

3 Answers   TCS,

For more RPG400 Interview Questions Click Here
Categories