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

what is the purpose of ovrdta and ovrata keywords ?

1487


difference between sflrcdnbr and sflnxtchg?

1162


what is rpg ?

1629


which are the relational operators in rpg?

1107


if dspatr(pc) and csrloc were specified for a format, which keyword would have priority?

1651


What is a query can be displayed without saving it?

1078


how many printer files can be defined in f specs ?

1615


what is the difference between packed decimal and zoned decimal?

3204


what opcode will be used to test the zone of a character field?

1765


what the purpose of ovrdta, ovrata keywords?

1930


define a shared access path?

1722


What is %CHECK?

1255


How to convert a spool file to PDF file in AS400?

1225


what are members?

1035


how do you read changed records backward in subfile?

1082