CLOSE Cursor

Description

Closes the SQL cursor CursorName; ends processing of CursorName.

Syntax

CLOSE CursorName ;

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).

NoteError handling It is good practice to test the success/failure code after executing a CLOSE cursor statement.

Examples

Example 1

This statement closes the Emp_cursor cursor:

CLOSE Emp_cursor ;