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

Suppose if I need to update a column, how you do that using
cursor?

Answer Posted / bobby

continuation of previous answer,

after cursor declaration, open the cursor and fetch the cursor. When the condition for update is satisified isue EXEC SQL UPDATE CURRENT OF.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between bind and rebind in db2?

1504


What is a db2 schema?

1294


What is the use of db2?

1110


If I have a view which is a join of two or more tables, can this view be updateable?

1184


ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

2115


What does db2 stand for?

1087


Comment whether the cursor is closed during commit or not.

1165


What is host variable in db2 cobol?

1129


What is difference between isnull and coalesce?

1101


What is commit in db2?

1099


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3202


What is database reorganization?

1179


How do I import data from excel to db2?

1126


Explain how can you do the explain of a dynamic sql statement?

1173


Differentiate between cs and rr isolation levels? Where do you specify them?

1115