Difference between revisions of "SQL CLOSE"

From Recital Documentation Wiki
Jump to: navigation, search
 
(One intermediate revision by one user not shown)
Line 8: Line 8:
  
 
==See Also==
 
==See Also==
[[DECLARE CURSOR]], [[DROP CURSOR]], [[OPEN]], [[SQL SELECT|SELECT]]
+
[[DECLARE CURSOR]], [[DROP CURSOR]], [[FETCH]], [[OPEN]], [[SQL SELECT|SELECT]]
  
  
Line 25: Line 25:
 
==Example==
 
==Example==
 
<code lang="recital">
 
<code lang="recital">
// Close the cursor
+
CLOSE accounts
EXEC SQL
+
CLOSE accounts;
+
 
</code>
 
</code>
  
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:SQL|CLOSE]]
 
[[Category:SQL|CLOSE]]
 
[[Category:Commands]]
 
[[Category:Commands]]

Latest revision as of 17:24, 22 December 2009

Purpose

Closes a cursor


Syntax

CLOSE <cursor>


See Also

DECLARE CURSOR, DROP CURSOR, FETCH, OPEN, SELECT


Description

The CLOSE command closes the specified cursor, releasing all resources and locks allocated when the cursor was opened. A cursor is a pointer to a logical table. A logical table is a temporary collection of data that satisfy conditions specified in a SELECT statement. After a cursor has been CLOSED, it may be accessed again by issuing another OPEN statement. The cursor is not released until a DROP CURSOR statement is issued. This command can only be used in Embedded SQL. The cursor must already be open.


Keywords Description
cursor The name of the cursor to be closed.


Example

CLOSE accounts


Products

Recital Server, Recital