Interested to Buy Any Domain ? << Click Here >> for more details...
What is the significance of the CURSOR WITH HOLD clause in
a cursor declaration?
- 4 Answers
- 30323 Views
- I also Faced
- E-Mail Answers
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
What is temporal table in db2?
define clustering index.
Define data page.
Which is faster delete or truncate?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is collection in db2 bind?
Outputs of explain are with matchcols = 0. What does this signify?
What is check constraint. Explain with example.
What is access path in db2?
How can you quickly find out the # of rows updated after an update statement?
What is the difference between db2 and oracle?
What is ibm db2 used for?
How can we retrieve the total number of records in RPG & CLLE?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
what is utility for parm lib
