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

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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

Question Posted / khbnaidu

Answers were Sorted based on User's Feedback



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

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

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

Answer / sandy

EXEC SQL DECLARE X CURSOR FOR
SELECT * FROM ABC
FOR UPDATE OF <COLUMN> ==>If we know the column we would
like to update.

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More DB2 Interview Questions

how can u nderstand the sql stmts executed successfully or not ?

1 Answers   TCS,

How to resolve -805 error in DB2?

1 Answers   Cap Gemini,

How are write I/Os from the buffer pool executed?

1 Answers  

What are PACKAGES ?

3 Answers  

What is db2 catalog database?

0 Answers  

What db2 400?

0 Answers  

Is it possible to precompile if db2 goes down?

4 Answers   Target,

Is ibm db2 free?

0 Answers  

What is temporal table in db2?

0 Answers  

How to find the maximum value in a column in the db2 database?

0 Answers  

what is datacom db?

2 Answers   CSC,

What os does db2 run on?

0 Answers  

For more DB2 Interview Questions Click Here
Categories