Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 1 Answers
- 2465 Views
- I also Faced
- E-Mail Answers
Answer Posted / david
use sql to update the field to 0.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
during execution, an rpg/400 program automatically follows a sequence of operations for each record that is processed. The built-in program cycle includes the following logical steps.
Please tell me how to read the records from a file with load an array of size with error conditions(The logic answer for this question is ARR is array of 99 elements Z-ADD 0 IDX *LOVAL SETLL FILE READ FILE 99 *IN99 DOWEQ *OFF IDX ANDLT 99 ADD 1 IDX MOVE FIELD ARR,IDX READ FILE 99 ENDDO).So,Please give me the complete of this code.
what happens when sflsiz = sflpag? What are the advantages and disadvantages?
what do you mean by an input subfile, what are the keywords required?
When it is desirable to describe files Internally?
give an eg of ACQ-(ACQUIRE),BIT OFF,BIT ON,DEALLOC,DUMP,FEOD,FORCE,MHHZO,MHLZO,MHLLZO,MLHZO,REL,RESET,TESTZ,TESTB,TESTN----GIVE SMALL EXAMPLE TO THE OPCODES...TO UNDERSTAND FUNCTIONING...........
How do u design a physical file, when you have 2 Unique fields like for eg in A student file student ID and student examination no both are unique
are there any useful c runtime apis that I can call from rpg iv?
How to write record if no field or the field are different in physical file in rpgle ?
How Chain operation copies the record's data to the input buffer for the program?
what is *place and *auto keyword in prtf ?plz explain
how do I preserve and clean the array?
do you use message subfiles? What are the necessary keywords required coding a message subfile?
What is the purpose of record level identifier?
can any one help in hawkeye and turnover or any change management system plzzzzz or send the documents to my mail id :gvsp.as4@gmail.com
