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
when would you prefer logical file than opnqryf?
what do we can do with the embedded sql statements?
can anybody give the interview questions list of RLU. plz mail me: dinesh_sati07@yahoo.com
which cl command is used to trap error messages during program execution?
what is the difference between sflclr and sflinz?
What Is The Difference Between Goto & Exsr?
what is a keyed physical file?
how would you design the process for a nightly, high volume check producing process that needs to select only records that are flagged to be processed?
which are the relational operators in rpg?
Hi,Please give me the the answer for these quesitons? 1.what is IFS and ICF and RAPE amd DISKET fils? explain with example please? 2.What is the difference between POST AND SPACE OPCODES? 3.Can anybody tell me default printerfile command and object type?
how can I give more performance to some selected pages?
define the rcvf command?
What is the Difference between command attention key and command function key ?
what is a query can be run in which mode?
what is the difference between udate and the system date?