Difference between revisions of "DROP CURSOR"

From Recital Documentation Wiki
Jump to: navigation, search
(Class)
 
(One intermediate revision by one user not shown)
Line 1: Line 1:
 
 
 
==Purpose==
 
==Purpose==
 
Frees up all system resources allocated to a cursor
 
Frees up all system resources allocated to a cursor
Line 17: Line 15:
  
 
This command can only be used in Embedded SQL.  The cursor must already be declared.
 
This command can only be used in Embedded SQL.  The cursor must already be declared.
 
  
  
Line 30: Line 27:
 
==Example==
 
==Example==
 
<code lang="recital">
 
<code lang="recital">
EXEC SQL
+
DROP CURSOR accounts
  DROP CURSOR accounts;
+
 
</code>
 
</code>
  
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:SQL]]
 
[[Category:SQL]]
 
[[Category:Commands]]
 
[[Category:Commands]]

Latest revision as of 14:44, 22 December 2009

Purpose

Frees up all system resources allocated to a cursor


Syntax

DROP CURSOR <cursor>


See Also

CLOSE, DECLARE CURSOR, OPEN, SELECT


Description

The DROP CURSOR command frees up all system resources allocated to the specified cursor. Cursors may be closed with the CLOSE statement, and then re-opened with the OPEN statement. The DROP CURSOR statement should only be used if the cursor is no longer needed.

This command can only be used in Embedded SQL. The cursor must already be declared.


Keywords Description
cursor The name of a declared cursor to be dropped.


Example

DROP CURSOR accounts


Products

Recital Server, Recital