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 to debug a batch job when it is in messagewait(mswg) status. I know the steps for batch ebugging, but im confusing with when we submit any job for batch debug we put in held state. So here also do same thing or any other way?

1355


What Is Ddm ?

1779


what is a logical file?

1925


explain the use of dftwrt display keyword?

1835


what is match field indicator?

1830


what is the necessary keyword for non-join logical file?

1890


how do handle file exception/error?

1230


all i need to know about cmpseqdat parameter in cmppfm, how it works and can we retrieve line sequence and date from the output?

2929


what is the maximum number of subroutines allowed in rpg?

1851


WHAT is STORED PROCEDURE CONCEPT IN AS400 WITH EXAMPLE?

2580


how to pick up the changed records every time in a subfile after the first change made ?

1892


what is externally described file ?

1738


define a shared access path?

1857


how does union file maintains record formats?

1172


Can level check error occur if we do chgpf?

1301