Multiple choice technology mainframe

Without the use of ________ keyword in a cursor, the cursor is closed each time a commit is performed

  1. WITH UR

  2. WITH ROLLBACK

  3. WITH CONTINUE

  4. WITH HOLD
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In DB2 and similar SQL databases, the WITH HOLD option on a cursor prevents the cursor from closing when a COMMIT operation is performed. Without this option, cursors close automatically at commit, requiring them to be reopened. WITH HOLD maintains cursor position across transaction boundaries.

Keep practicing — related questions