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
- 2561 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
can you debug ile rpg program using isdb?
can anybody help me to solve this problem. the program that i m checking display error message saying "Record format for file AJDSPFFD does not match model file and decimal error. how to solve this problem. The AJDSPFFD is snapshot the AJTLOG that is the audit trail list.
What are the types of identifiers?
When we have a file with Duplicate records and I want to read the unique record from the file. For example a file containing Emp Name as 'Ram' and there are 3 entries of it. So how to read a unique record from File?
How can we override a file during runtime in rpg?
are there any useful c runtime apis that I can call from rpg iv?
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.
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
what was the robotech rpg?
Interviewer asked me write down DDS for load all subfile .can anybody write dds
how do I declare a table or array in rpg iv?
What is a record lock error?
thanks mr.Harshad R Suryawaunshi,i'm new to as400 i think you are telling in rpgile i know only rpg400 if possible can you tell in rpg400
how can I tell when to replace the array?
What is file identifier where we can use?
