Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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....?

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


Please Help Members By Posting Answers For Below Questions

when would you prefer logical file than opnqryf?

2329


what do we can do with the embedded sql statements?

1010


can anybody give the interview questions list of RLU. plz mail me: dinesh_sati07@yahoo.com

2649


which cl command is used to trap error messages during program execution?

1391


what is the difference between sflclr and sflinz?

1676


What Is The Difference Between Goto & Exsr?

1592


what is a keyed physical file?

1738


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?

1530


which are the relational operators in rpg?

1072


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?

2535


how can I give more performance to some selected pages?

990


define the rcvf command?

1642


What is the Difference between command attention key and command function key ?

1305


what is a query can be run in which mode?

1253


what is the difference between udate and the system date?

1908