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 would be the effect on the field where reverse image, underline and high intensity?

7 Answers   IBM,


What is significance of a file designated as a Primary file in Rpg400 program....also what's use of secoundry file

1 Answers  


can you debug ile rpg program using isdb?

0 Answers   IBM,


I want to add 10 days in current date. how it is possible in CL program...?

10 Answers   CSC,


Hi, Can anybody give me real sinario for SFLRCDNBR?with example?

2 Answers  






what is a rpg?

0 Answers   IBM,


What are different ways to pass data between programs and which one is the efficient way?

5 Answers  


When it is desirable to describe files Internally?

0 Answers  


1. Which Built-In-Function will you use to achieve the following functionality? CLONO1NO2NO3 Factorl÷÷+OpcdeFactor2++÷ResultLenDHHiLoEq C QTY IFLT *ZERO C QTY MULT -1 QTY C ENDIF a) %ABS b) %TRIM c) %TRIMS d) %UNS

3 Answers   IBM,


WHAT IS MENT BY RECORD LEVEL IDENTIFIER ? WHAT IS THE PURPOSE OF THIS?

1 Answers  


I need to generate outfile for object of all the user lib. in the sysmte using cmd DSPOBJD. But this cmd is correcpted in my server,Any body tell me is there any alternative...?

2 Answers  


why subproc not run in dftactgrp?????/plz explain

2 Answers   CSC,






Categories