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 %CHECK?
Can level check error occur if we do chgpf?
what are the two record formats a subfile contain ?
which are the relational operators in rpg?
can a single screen format occupy a screen area above and below a subfile format ?
what is a join logical file?
How to Define a Procedure in RPG?
how you will know whether you are in sfldrop or sflfold mode?
Why we are not able to perform insert delete and update operation in Join logical file?
what are the important factors in error message subfile ?
what keyword must be used with protect keyword ?
what is term cua , saa?
Write a logic program for knowing the repeated number of a vowels in a given program?
if dspatr(pc) and csrloc were specified for a format, which keyword would have priority?
define the purpose of the iter operation?