Interested to Buy Any Domain ? << Click Here >> for more details...
What happens to a cursor after a commit?
- 3 Answers
- 9913 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 are types of indexes?
What do you mean by cursor?
What is a result table?
What is filter factor?
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)
What is the use of commit in db2?
how can u nderstand the sql stmts executed successfully or not ?
Is schema the same as database?
How to handle null values in db2
What is a SELECT statement?
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?
how to resolve -811
COBOL 
