To allow DB2 to close a cursor after a commit or a rollback operation, we use the WITH HOLD option of the DECLARE CURSOR statement.
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- DB2 WITH HOLD option What does WITH HOLD option do ?
- Without the use of ________ keyword in a cursor, the cursor is closed each time a commit is performed
- When you COMMIT, is the cursor closed?
- When you COMMIT, is the cursor closed?
- Which type of cursor should be used so that its position will be maintained between transactions
- A Rollback statement cannot be used to close transaction.
- A Rollback statement cannot be used to close transaction.
- A Rollback statement cannot be used to close transaction.