CLOSE Statement

Closes an open cursor. CLOSE leaves the data structures accessible for reopening; however, modifications or fetches are not allowed until the cursor is reopened.

Syntax

CLOSE cursor_name

where

cursor_name

Specifies the name of an already-declared cursor.