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

I have 3 cursors declared. Cursor1 retieves some data.
Based on this curso2 will also fetches some data. In cursor3
(using for some updation) I'm using the data retrieved by
the above 2 cursor. My question is, while working with
cursor3, periodically if I give commit, will all the three
crsors will be closed or only cursor3 will be closed?

Question Posted / arunkumar.vijay

Answers were Sorted based on User's Feedback



I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some..

Answer / sridhar

COMMIT will close all the cursors, if the cursors are not
delcared using 'WITH HOLD'.

Is This Answer Correct ?    37 Yes 0 No

I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some..

Answer / purushotham

Obviously it will close all the cursors.

Is This Answer Correct ?    3 Yes 2 No

I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some..

Answer / srisri

COMMIT will close all the cursors, if the cursors are not
delcared using 'WITH HOLD'.

Is This Answer Correct ?    1 Yes 0 No

I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some..

Answer / r.l.v.krishna

COMMIT WILL CLOSE ALL THE CURSORS IF U R NOT MENTIONED WITH HOLD OPTION IN THE DECLARATION PART OF THE CURSOR....

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)

9 Answers   IBM,

is it possible to get -811 error when you use cursors. why?

2 Answers   IBM,

Is ibm db2 open source?

0 Answers  

what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?

2 Answers  

What do you mean by cursor?

0 Answers  

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

0 Answers  

What is reorg and runstats in db2?

0 Answers  

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

0 Answers  

db2 restart logic ?

1 Answers   DELL, HTC, UHG,

what is a plan and how do you refer the plan in the program?

2 Answers   Xansa,

What is query for your birthday date should be in hours,minute and seconds format?

1 Answers   Fidelity,

what is main use of table space and index object? please its urgent

5 Answers   CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,

For more DB2 Interview Questions Click Here
Categories