CLOSE Cursor SQL statement

Description

Closes the SQL cursor CursorName;
ends processing of CursorName.

Syntax

Parameter	Description
CursorName	The cursor you want to close

Usage

This statement must be preceded by an OPEN statement
for the same cursor. The USING TransactionObject
clause is not allowed with CLOSE; the transaction
object was specified in the statement that declared the cursor.

CLOSE often appears in the script that
is executed when the SQL code
after a fetch equals 100 (not found).

Examples

---