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
what is the purpose of ovrdta and ovrata keywords ?
difference between sflrcdnbr and sflnxtchg?
what is rpg ?
which are the relational operators in rpg?
if dspatr(pc) and csrloc were specified for a format, which keyword would have priority?
What is a query can be displayed without saving it?
how many printer files can be defined in f specs ?
what is the difference between packed decimal and zoned decimal?
what opcode will be used to test the zone of a character field?
what the purpose of ovrdta, ovrata keywords?
define a shared access path?
What is %CHECK?
How to convert a spool file to PDF file in AS400?
what are members?
how do you read changed records backward in subfile?