Hi Viewers can any body explain me how to update and ahange
the already existed data in physical file using subfile ?
please explain me with the code if possible?



Hi Viewers can any body explain me how to update and ahange the already existed data in physical fi..

Answer / dx

first read all records from physical file and move to subfile
then read change records from subfile format by opcode READC
in loop it will work

eg- readc sfl 56
*in56 downe *on
move dspfile physical file
updat sfl
enddo

Is This Answer Correct ?    7 Yes 0 No

Post New Answer

More RPG400 Interview Questions

1. What is bound-by-call and bound-by-reference? 2. Where and why is *Nomain used? 3. What are the difficulties faced by programmers when using service programs? 4. Explain the different ways of parsing and compiling XML in iSeries.

2 Answers  


how to check on which PF , the LF is dependant ?

4 Answers   IBM,


1..Write an sql query to find the employee name who is having 2 phone numebr? 2.Write an sql query to the the second highest salary of the employee?

4 Answers  


3 members in databasefile .how to read records from all the members??

6 Answers   CTS,


How do I link an existing logical file to it's Physical File without recompiling?

2 Answers  






if there is pf in two libraries and there is a logical file based on the PF, how to find the pf on which the pf is based.

2 Answers   TCS,


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

3 Answers   TCS,


How to declare the dynamic(run time) array in rpgle? can you please give example

2 Answers   Polaris,


How to update only a field of a PF in an RPG program. I don't want to update the record, only one field.

2 Answers  


What would be the effect on the field where reverse image, underline and high intensity?

7 Answers   IBM,


explain sflclr, sflend, sfldlt, and sflcsrrrn?

0 Answers   IBM,


what is data area and how it is used in rpg program ?

0 Answers   IBM,


Categories