Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


CLOSE


Closes a cursor.

Usage

Embedded/Procedural.

Description

The current state of the named cursor is closed.

If any states of the cursor have been saved on a stack by successive OPEN statements, see OPEN, the most recently saved cursor state is restored. Information about whether there are cursor states remaining on the stack is returned as diagnostic information. Otherwise the cursor is closed (deactivated), and may not be used until it has been re-opened with a new OPEN statement.

If the optional keyword RELEASE is used, all resources allocated to the cursor including any stacked references are destroyed. The cursor must be re-prepared (in dynamic SQL) and reopened before it can be used again.

See ALLOCATE CURSOR for a description of extended cursors.

Restrictions

In a Procedural usage context, a cursor cannot be specified by extended-cursor-name.

Notes

For the statement to be valid, the cursor in question must be open.

Standard Compliance

Standard
Compliance
Comments
X/Open-95
SQL92
MIMER EXTENSION
Support for the RELEASE keyword is a Mimer SQL extension.



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Reference Manual TOC PREV NEXT INDEX