What is the significance of the CURSOR WITH HOLD clause in
a cursor declaration?
- 4 Answers
- 29298 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 are packages in db2?
How to get the ddl of a table in db2?
What is drop table?
What is explain plan in db2?
What is a plan and package in db2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Define predicate?
What is the use of db2 optimizer?
What is a storage group (stogroup)?
What is precompiler in db2?
How to find primary key of a table in db2?
Is it possible using max on a char column?
What is an instance in db2?
What is host variable?
How do I delete a table in db2?
