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?

RenDC

» Interview Questions and Answers » Questions » News Feed » Tutorials » rendc.com

Question and Answer:

Home IBM RPG400

⟩ 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?

Using SQL, we can set second field value as '0'

Is this answer helpful?
0 Yes | 0 No

154 views

More Questions for you:

How can return codes be tested before execution of a job step?

How can values be passed from the job stream to an executable program?

What is the purpose of the DD KEYLEN parameter?

What is the function of the STEPLIB DD statement?

What is concatenating?

Can you explain some reserved queue names of IBM Websphere MQ?

Tell me how does MQ support the Integration?

What is Asynchrony in MQ?

Explain how to define a buffer pool for holding messages in main storage?

What is the significance of MQ Series?

rendc.org

Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."

Quick Links:

Interview Question and Answer Questions Add Questions News-Feed Add Posts HR Hacks Tutorials Profile rendc.com memeph.com

Question and Answer:

Home IBM RPG400

⟩ 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?

Popular Answers:

* There is no answer to the above question yet.

More Questions for you:

Quick Links:

Question and Answer:

Home IBM RPG400

⟩ 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?

Popular Answers:

* There is no answer to the above question yet.

More Questions for you:

BE THE FIRST TO KNOW

Quick Links: