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 to debug a batch job when it is in messagewait(mswg) status. I know the steps for batch ebugging, but im confusing with when we submit any job for batch debug we put in held state. So here also do same thing or any other way?
What Is Ddm ?
what is a logical file?
explain the use of dftwrt display keyword?
what is match field indicator?
what is the necessary keyword for non-join logical file?
how do handle file exception/error?
all i need to know about cmpseqdat parameter in cmppfm, how it works and can we retrieve line sequence and date from the output?
what is the maximum number of subroutines allowed in rpg?
WHAT is STORED PROCEDURE CONCEPT IN AS400 WITH EXAMPLE?
how to pick up the changed records every time in a subfile after the first change made ?
what is externally described file ?
define a shared access path?
how does union file maintains record formats?
Can level check error occur if we do chgpf?