SQL Language Guide : 8. SQL Statements : CLOSE
 
Share this page                  
CLOSE
Valid in: ESQL, OpenAPI, ODBC, JDBC, .NET
The CLOSE statement closes an open cursor.
The CLOSE statement has the following format:
EXEC SQL CLOSE cursor_name
cursor_name
Specifies the cursor name using a quoted or unquoted string literal or a host language string variable. If cursor_name is a reserved word, it must be specified in quotes.
The cursor_name must have been previously defined in your source file by a DECLARE CURSOR statement. Once closed, the cursor cannot be used for further processing unless reopened with a second OPEN statement. A COMMIT, ROLLBACK, or DISCONNECT statement closes all open cursors.
A string constant or host language variable can be used to specify the cursor name.
Embedded Usage
In an embedded CLOSE statement, a string constant or host language variable can be used to specify the cursor name.
Usage in OpenAPI, ODBC, JDBC, .NET
In OpenAPI, ODBC, JDBC, and .NET, Close cannot be directly issued on a cursor name, but can take handles or objects that perform the same task.
Permissions
This statement is available to all users.
Locking
In the CLOSE statement, closing a cursor does not release the locks held by the cursor. (The locks are released when the transaction is completed.)
Related Statements
DECLARE CURSOR
FETCH
OPEN