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 / surya siram
UPDATE FF SET SUBSTR(RCD, 6, 1) = 'Y' WHERE SUBSTR(RCD, 6, 1) = 'N'
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Difference Between Ca & Cf?
when would you prefer logical file than opnqryf?
how can you detect and handle a record lock situation?
list some of the commonly used commands for debugging?
how to define global parameter in ile ?
how will you display a particular page in subfile ?
In 'o' Specs What Is The Opcode For Write?
what is rpg ?
what is maximum number of arrays allowed in rpg?
what are different types of substems?
how can u check no of records in a file?
which are the query selection criteria, which can be given in a query?
Hello, I have created a CMD type object. In one of the fields in Display file , I would like to see All the Source files present by pass the name of Library. Tried using CHoice(Keyword) and Choicepgm on PARM , but doesn't seems to be working. Any help please..
How can we read file using curser? how to define a curser?
which of the following operations does not zero the field flda defined as 4,0?