Step 6: Closing the cursor

If you have processed the rows of a result table using a serial cursor, and you want to use the cursor again, issue a CLOSE statement to close the cursor before opening it again.

The statement looks like this:

EXEC SQL
 CLOSE cursor-name
END-EXEC.

If you processed the rows of a result table and you do not want to use the cursor again, you can let the system close the cursor. The system automatically closes the cursor when:

  • A COMMIT without HOLD statement is issued and the cursor is not declared using the WITH HOLD clause.
  • A ROLLBACK without HOLD statement is issued.
  • The job ends.
  • The activation group ends and CLOSQLCSR(*ENDACTGRP) was specified on the precompile.
  • The first SQL program in the call stack ends and neither CLOSQLCSR(*ENDJOB) or CLOSQLCSR(*ENDACTGRP) was specified when the program was precompiled.
  • The connection to the application server is ended using the DISCONNECT statement.
  • The connection to the application server was released and a successful COMMIT occurred.
  • An *RUW CONNECT occurred.

    Because an open cursor still holds locks on referred-to-tables or views, you should explicitly close any open cursors as soon as they are no longer needed.

Parent topic: Examples: Using a cursor