CLOSE¶
Valid in: ESQL, OpenAPI, ODBC, JDBC, .NET
The CLOSE statement closes an open cursor.
The CLOSE statement has the following format:
- 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.)