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

What is the significance of the CURSOR WITH HOLD clause in
a cursor declaration?

Question Posted / abhisek

Answer Posted / abhisek

As soon as the COMMIT statement is executed in a
program,the cursor gets automatically closed,So we need to
give CURSOR WITH HOLD clause,in order to keep it open after
execution of the COMMIT statement.

Is This Answer Correct ?    43 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is bufferpool in db2?

1097

What is the use of dclgen in db2?

1135

What is a Foreign Key?

1139

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

2092

What is the reason behind not using select * in embedded sql programs?

1169

What is null indicator in cobol db2?

1111

How many types of page locks can be held in db2?

1090

What is db2 plan table?

1110

What is an instance database?

1098

What is copy pending status in db2?

1184

How can you count the number of rows from a table tab?

1137

What is the difference between oracle and db2?

1173

What is netezza database?

1082

Why do we bind in db2?

1275

Explain package in db2 and its advantages?

1272