Deactivates a cursor.
close cursor_name
is the name of the cursor to close.
Closes the cursor named authors_crsr:
close authors_crsr
The close command essentially removes the cursor’s result set. The cursor position within the result set is undefined for a closed cursor.
Adaptive Server returns an error message if the cursor is already closed or does not exist.
ANSI SQL – Compliance level: Entry-level compliant.
No permission is required to use close.
Commands deallocate cursor, declare cursor, fetch, open
