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 / murali
Update <FileName> set substr(<Field Name>,6,1) = 'Y' where
substr(<Field Name>,6,1) = 'N'
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
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..?
maximum number of subfiles that can defined in a rpg program for one display file is?
what is rpg fixed logic cycle?
define a output queue?
what is maximum number of arrays allowed in rpg?
what is the difference between seton lr and retrn?
explain the difference between defining subfile and message-subfile?
why is the declare cursor statement is used for?
where can you specify an indicator in lokup operation?
what opcode could be used to test an alphanumeric field for all numeric values?
how to pick up the changed records every time in a subfile after the first change made ?
what is a program described file in rpg?
how can I automatically refresh a web page?
What is RETURN CURSER LOCATION in subfile?
explain the use of dftwrt display keyword?