Reference Guide > TDV SQL Script > SQL Script Statement Reference > CLOSE
 
CLOSE
The CLOSE statement in SQL Script is used to close a cursor. See DECLARE CURSOR of Type Variable for details on declaring cursors.
Syntax
CLOSE <cursor>
Errors
The following table describes the errors that can occur while executing a CLOSE statement.
Error Message
Cause
Uninitiallized cursor
A cursor variable is used and is not initialized at the time it is opened.
Cursor is not open
CLOSE was invoked when the cursor was not open.