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 / mahalakshmi

update file1 set file1 = 'AS400YDB2400' where file1 = 'AS400NDB2400'

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how do you read data area in an rpg program?

1833


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..?

1924


How to avoid using indicators in ile ?

1286


which indicator is used for read?

1145


. How to know why the OPM job is in MSGWAIT state?..WHAT COULD BE THE REASON FOR it?

7957


what key word is used when screen is re-display?

1135


how can you detect and handle a record lock situation?

1995


what is the use of unique keyword and what level it is defined?

1609


Difference Between Skip Before & Space Before?

1234


How can we update a specific field in RPG?

1367


define data structure?

1772


WHAT IS AS/400 SYNORIO?

3365


define what a data queue is along with a brief example of what it may be used for?

1822


what is the function of cpyf command?

1683


when would you prefer logical file than opnqryf?

2468