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

Can we declare cursor in Procudere division or open the
cursor in the Working storage section.

Is there any particular rules in the usage of cursors lifecycle

Question Posted / srprev


Can we declare cursor in Procudere division or open the cursor in the Working storage section. ..

Answer / omkar panda

yes we can declare cursor in procedure division but we cant
open the cursor in working-storage section as it is an
executabale statement.the lifecycle of cursor is as below
1>declare cursor
2>open cursor
3>fetch cursor
4>close cursor

Is This Answer Correct ?    20 Yes 2 No

Post New Answer

More DB2 Interview Questions

How to view db2 table structure?

0 Answers  

List out the buffer pools in db2

0 Answers  

What is Declaration Generator(DCLGEN)?

1 Answers  

What is the purpose of the QUIESE Utility?

1 Answers  

What is the specific need of Plan and..where are the tables in DB2 are physically saved

3 Answers   Infosys,

What is isolation level in db2?

0 Answers  

What are foreign keys in db2?

0 Answers  

what is difference between Static call and Dynamic call? How does it function?

1 Answers   Syntel,

What does DSNDB07 database do?

2 Answers  

What does an outer join do?

1 Answers   CTS,

what is parm utility

2 Answers   IBM,

How can deadlocks be resolved?

0 Answers  

For more DB2 Interview Questions Click Here
Categories