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 |
what are the key words you must use when using a subfile?
in which journalling which attributes are necessary??/
two types of read performed in dataqueue?????
can anyone say,what is the use of operation extended H/N/P?
What is the OPEN and CLOSE accesspath?
while i am using the dspmsg command on comman line in Mocha am getting error like Not authorized to message queue message my messagequeue Name? can anybody help me how to change my message queue Am anable to see my messages in message queue
A rpg or clp command to find if the file field is defined as a character or numeric field.
How to write record if no field or the field are different in physical file in rpgle ?
How can we access Interactive job LDA in Batch Job?. and How we can access a file in interactive QTEMP lib in Batch job?.
How do you find whether a record is locked or not?
suppose a job is running for 15 minutes after that it goes to message wait? what are the impact analysis
why we do STRSRVJOB in batch debugging in as400