CLOSE - Close cursor

You use CLOSE to close a cursor you declared with the DECLARE CURSOR statement and opened with OPEN or RESTORE.

The cursor description is retained. The current cursor position can be saved before closing with STORE (not applicable for local cursors in procedures).

You can close a cursor any number of times and, if desired, open it again with new variable values.

---

CLOSE cursor

---

cursor

Name of the cursor to be closed.

Example

Close the cursor CUR_CONTACTS.

CLOSE cur_contacts

See also

DECLARE CURSOR, FETCH, OPEN, RESTORE, STORE