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

Update <FileName> set substr(<Field Name>,6,1) = 'Y' where
substr(<Field Name>,6,1) = 'N'

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is sflinz and sflrna?

1518


define the purpose of the *bcat function?

1544


The content of Physical file is as below: hfcftp wruquief SENDPASV 0 CDUP ASCII GET 01100901.CSV ramndk/ECP505.EC0110090 (REPLACE QUIT Thw above commands will get executed when we call STRTCPFTP from CL program.... Now if I want to use SFTP what can be the solution? plz reply in detail....Thank you for ny help... I m using RPG/ILERPG to download...

2366


name few ibm supplied libraries?

2124


define a shared access path?

1768


what is the purpose of ovrdta and ovrata keywords ?

1513


which cl command can be used at program execution to redirect the file named in an rpg program?

1204


how to define global parameter in ile ?

1191


define the purpose of the iter operation?

1852


what is overlay?

1138


the maximum number of subfiles that can defined in a rpg program for one display file is ___ .

3291


What Does 'sr' In Columns 7-8 Of C Specs Mean?

1742


what does vldcmdkey means?

1367


what the purpose of ovrdta, ovrata keywords?

1962


what is procedure prototype and procedure interface.

1227