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
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / mahalakshmi
CPYFRMIMPF and then update the records by using SQL
Is This Answer Correct ? | 0 Yes | 0 No |
How to read alternative records in a pf by using rpg?
Need a sql query: retrieve all duplicate records in table?
difference between CHAIN and READE?
How to check which are the pgms using 1 perticulate file.? I know there is many tool available for X-reference...but need to know is there any command available in the system...?
suppose we have 10 members in physical file and i have to use 4 out of 10 so how can we read this in RPG
What is the diff bw PF/LF Name and their Record format name? what is restriction in record format then file name?
I am reading a file in CL program. and MONMSG CPF0864 has arrived means EOF has arrived. Now i want to read this file again. How i can do this?
5 Answers CitiGroup, Symphony,
Suppose in CL we reach at end of file and again we have to reach from 1 record
i have a file with the values 10, 20, 30, 40, if am setll with the value 25 then readp, so what it will return?
1.How to read a subfile in out put mode? 2.what are the keywords used to share same file? 3.using composite key which rpg code used?
Why did we give STRSRVJOB while debugging batch program
Why there is invention of RPG if we can do insert update delete in CL through SQL.Why the rise of RPG?