Interested to Buy Any Domain ? << Click Here >> for more details...
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....?
- 5 Answers
- 9687 Views
- I also Faced
- E-Mail Answers
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
what is a query can be run in which mode?
what is the difference between packed decimal and zoned decimal?
what are dds required for subfile?
What is the difference between non-join logical files and join logical files?
how do you use exceptional write in c specs?
which are control break logic indicators?
how to pick up the changed records every time in a subfile after the first change made ?
when would you prefer logical file than opnqryf?
in conjunction with which statements can orxx and andxx conditions be used ?
what opcode could be used to test an alphanumeric field for all numeric values?
How to reverse the string in rpg
how do you read changed records backward in subfile?
what is arrival sequence?
at what level s,o are defined and what they will do?
what is a primary file?
