Difference between revisions of "DROP CURSOR"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision: SQL) |
Helen.george (Talk | contribs) |
||
| (3 intermediate revisions by 2 users 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 | ||
| − | |||
==Syntax== | ==Syntax== | ||
DROP CURSOR <cursor> | DROP CURSOR <cursor> | ||
| − | |||
==See Also== | ==See Also== | ||
[[SQL CLOSE|CLOSE]], [[DECLARE CURSOR]], [[OPEN]], [[SQL SELECT|SELECT]] | [[SQL CLOSE|CLOSE]], [[DECLARE CURSOR]], [[OPEN]], [[SQL SELECT|SELECT]] | ||
| − | |||
==Description== | ==Description== | ||
| Line 16: | Line 13: | ||
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. | ||
| − | + | {| class="wikitable" width="100%" | |
| − | {| class="wikitable" | + | |
!Keywords||Description | !Keywords||Description | ||
|- | |- | ||
| Line 23: | Line 19: | ||
|- | |- | ||
|} | |} | ||
| − | |||
==Example== | ==Example== | ||
| Line 29: | Line 24: | ||
DROP CURSOR accounts | DROP CURSOR accounts | ||
</code> | </code> | ||
| − | |||
==Products== | ==Products== | ||
| − | + | Lianja Server, Lianja | |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:SQL]] | [[Category:SQL]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
Latest revision as of 11:21, 30 January 2013
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
Lianja Server, Lianja
