What happens to a cursor after a commit?
- 3 Answers
- 8979 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / angoca
The commit will close the cursor if this last was not
declared with the 'with hold' option.
| Is This Answer Correct ? | 14 Yes | 0 No |
If the cursor is defined with "WITH HOLD" option, it will NOT closed even after the commit operation, else cursor will be closed.
| Is This Answer Correct ? | 0 Yes | 0 No |
What do you mean by commit and rollback?
What is Skeleton cursor table (SKCT)?
What is the default page size of buffer pools?
What is correlated subquery?
What are the functions of Bind?
I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.
How can you find out the # of rows updated after an update statement?
Is it possible using max on a char column?
Mention data types used in db2 ?
What information is contained in a SYSCOPY entry?
What is the difference between db2 and oracle?
Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....
COBOL 
