I have 1 rd in my flat file.
say reord from 1 to 10 position : 'AS400NDB2400'
I need to change the value from N to Y
using SQL stmt ...How can I update this....?
Answer Posted / mahalakshmi
update file1 set file1 = 'AS400YDB2400' where file1 = 'AS400NDB2400'
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how do you read data area in an rpg program?
If i change any file through application after entering data , how to check which file is updated through applications . For call stack we takes esc 3 then we chose 11..But What is answer of below qtn..?
How to avoid using indicators in ile ?
which indicator is used for read?
. How to know why the OPM job is in MSGWAIT state?..WHAT COULD BE THE REASON FOR it?
what key word is used when screen is re-display?
how can you detect and handle a record lock situation?
what is the use of unique keyword and what level it is defined?
Difference Between Skip Before & Space Before?
How can we update a specific field in RPG?
define data structure?
WHAT IS AS/400 SYNORIO?
define what a data queue is along with a brief example of what it may be used for?
what is the function of cpyf command?
when would you prefer logical file than opnqryf?