Difference between revisions of "DROP CURSOR"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
==Class== | ==Class== | ||
SQL Applications | SQL Applications | ||
| Line 36: | Line 33: | ||
<code lang="recital"> | <code lang="recital"> | ||
EXEC SQL | EXEC SQL | ||
| − | DROP CURSOR accounts; | + | DROP CURSOR accounts; |
</code> | </code> | ||
Revision as of 10:14, 29 April 2009
Class
SQL Applications
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
EXEC SQL DROP CURSOR accounts;
Products
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
