What happens to a cursor after a commit?
- 3 Answers
- 8423 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 |
Is db2 a mainframe database?
List out the three types of page locks that can be held.
What do you do to keep the cursor from closing after a commit?
What Utility is used to migrate DB2 from one release to the next?
What is tablespace?
What does db2 mean?
Can SQL statements/queries be included in a copybook?
How to define the data items to receive the fetch items for the SQL?
What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
what is db2 restart?
What is dpf in db2?
what is the difference between join and union?
COBOL 
