Suppose my file has 10 fields and I want to make the 2nd field zeros in all records. And assume I have millions of records and I dont want to read each record and update the desired field with 0. Any other way to do this in one step operation?



Suppose my file has 10 fields and I want to make the 2nd field zeros in all records. And assume I ha..

Answer / david

use sql to update the field to 0.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More RPG400 Interview Questions

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,


How to index LF by relative record no (RRN)

1 Answers  


where we give the MSGSFL in rpg400?

4 Answers  


Can we used ovrdbf command after the opnqry file if yes then What will be out put of your program?

4 Answers   IBM,


how do I declare a minor?

0 Answers   IBM,






if i have three programs progA,progB and progC .now i call progB from progA. but the progB does not exist . now i want to call progC instead of starting dump. how can we achieve this.

10 Answers   Four soft,


What are the necessary keywords required to code a message subfile?

3 Answers  


What is the syntax of passing parameters to a procedure by value?

1 Answers  


1.Suppose my file has 10 fields and I want to make the 2nd field Zeros in all records. And assume I have millions of records and I dont want to read each record and update the desired field with 0. Any other way to do this in one step operation? 2. Assume my file has 100 records and I want to see only first 10 records. Is this possible through LF? 3.I have 3 jobs A B and C. I want to submit B after successful completion of A and want to submit C after successful completion of B. Without using job scheduler or job queue, how can i do that through CL program? 4.What is difference between Bind by copy and bind by reference?

4 Answers   Virtusa,


Suppose we have one database file and it is used by 5 programs and in 3 program we have to add some records in datbase file s what is the impact on other program?

0 Answers  


what is post opcode do

1 Answers   CTS,


what is use of sflnxtchg and use of MDT(modify data tag).both r same r not and can we use these on dspf and subfile.

2 Answers  


Categories