Suppose my file has 10 fields and I want to make the 2nd field zeros in all reco

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?

Question Posted / rohit thakur

1 Answers
2560 Views
I also Faced
E-Mail Answers

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 ?

1 Yes

0 No

Post New Answer

More RPG400 Interview Questions

How to set on/off a group of indicators in a single statement?

3 Answers

how can we can we the data decimal error?how can we open such file in support

1 Answers

i'm working on progA , in that program i want to see the userids of the users who work on this program?

10 Answers Four soft,

How Commitment and Roll back control is used in as400, explain with real time senario ???

2 Answers Acolite, HSBC,

how does the rpg element work?

0 Answers IBM,

What is the difference between iter and do?

0 Answers

can we use cl programming to update or delete physical files

12 Answers

When a object will be locked & when a record will be locked? Plz explain.

2 Answers

Hi guys, anybody know How RPG/400 code can be converted to RPG IV code with a single command?

1 Answers

Can a run time array be declare like below with no specified number of elements ? Is it possible ? DFLD_ARRAY 7 DIM() INZ(*blanks) What does this mean ? Does this mean that the number of array elements will be dynamically declared during run time ?

1 Answers TCS,

difference between CHAIN and READE?

8 Answers HCL,

can anybody explain significance of *loval setll with example code????

3 Answers HSBC,

For more RPG400 Interview Questions Click Here